Bank account opening balance

[Joseph Siame]

Hi 

I have setup a Bank account in my chart of accounts, but i cant seem to issue an opening balance.

I used the journal voucher(cash voucher) function to debit my bank account. but it doesnt seem to show when i check my bank account ledger.

any assistance would be of great help.

Thanks

Joseph

[Rushabh Mehta]

Did you submit the voucher

Sent from mobile

--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/NGswLiuyZRcJ.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Joseph Siame]

Hi 

I managed to sort out bank voucher issue. i had to clear the cache.

I have another problem i am trying to update my pricelist and don't seem to understand the format needed. i tried creating an excel document with these 3 headings "Item", "price", and "Currency" and uploading but i got this error

 

----Start entering data below this line---- what is the correct format and how do i go about importing and using that pricelist?

Any assistance will be of great help.

Joseph

On Thursday, 13 December 2012 16:55:30 UTC+2, rushabh wrote:

Did you submit the voucher

Sent from mobile

On 13-Dec-2012, at 8:23 PM, Joseph Siame <thatdu...@gmail.com> wrote:

Hi 

I have setup a Bank account in my chart of accounts, but i cant seem to issue an opening balance.

I used the journal voucher(cash voucher) function to debit my bank account. but it doesnt seem to show when i check my bank account ledger.

any assistance would be of great help.

Thanks

Joseph

--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+unsub...@googlegroups.com.

[Umair Sayyed]

Joseph,

Please find the attached excel file. Its a  template to import Price List in the system. Looking at columns name provided, Pricelist Name column is missing in your template.

--
Thanks and Regards,
Umair Sayyed
um...@erpnext.com
www.erpnext.com

To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/0WLVS5i1-DMJ.

[Joseph Siame]

Hi

Ok, so with the excel document you sent me, is this the correct order of data to input

ID                |    price_list_name      |     Currency       |  Ref Rate

------------------------------------------------------------------------------------------------------

item_name       My_pricelistname       My_currency        My_Ref_Rate

I have tried and Just want to confirm 'cause the column headings for the first two columns are a little confusing.

Thanks

Joseph

To unsubscribe from this group, send email to erpnext-developer-forum+unsubscr...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/NGswLiuyZRcJ.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+unsub...@googlegroups.com.

[Umair Sayyed]

Hi,

You got the column headings right.

1. ID  stands for Item Code.
2. Price List should be as defined in Price List master (eg. Standard, Default Price List).
3. Currency will one in which you maintain your price List. Price is mostly in base (i.e. Customer's) currency.
4. Ref Rate is selling rate before tax.

Hope this helps.

--
Thanks and Regards,
Umair Sayyed
um...@erpnext.com
www.erpnext.com

To unsubscribe from this group, send email to erpnext-developer...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/p2G5gjSEICMJ.

[Joseph Siame]

Hi 

Ok thank you for confirming that, it has definitely helped.

Thanks

Joseph

To view this discussion on the web visit https://groups.google.com/d/msg/erpnext-developer-forum/-/0WLVS5i1-DMJ.

For more options, visit https://groups.google.com/groups/opt_out

--
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
To post to this group, send email to erpnext-dev...@googlegroups.com.
To unsubscribe from this group, send email to erpnext-developer-forum+unsub...@googlegroups.com.