Bank account opening balance

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 er...@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un...@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.

 

 

Did you submit the voucher

Sent from mobile

On 13-Dec-2012, at 8:23 PM, Joseph Siame <th...@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 er…@googlegroups.com.

To unsubscribe from this group, send email to erpnext-developer-forum+un…@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 er...@googlegroups.com.

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

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

 

 

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 <th...@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+un…@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 er...@googlegroups.com.

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

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.

 

 

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



On Fri, Dec 14, 2012 at 2:29 PM, Joseph Siame <th…@gmail.com> wrote:

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 <th...@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+un…@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 er…@googlegroups.com.

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


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



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

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

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

 

 

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

On Friday, 14 December 2012 11:56:46 UTC+2, Umair Sayyed wrote:
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



On Fri, Dec 14, 2012 at 2:29 PM, Joseph Siame <th…@gmail.com> wrote:

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 <th...@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+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+un…@googlegroups.com.


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



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er...@googlegroups.com.

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

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

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

 

 

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

On Fri, Dec 14, 2012 at 4:11 PM, Joseph Siame <th...@gmail.com> wrote:
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

On Friday, 14 December 2012 11:56:46 UTC+2, Umair Sayyed wrote:
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


On Fri, Dec 14, 2012 at 2:29 PM, Joseph Siame <th...@gmail.com> wrote:
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 <th...@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+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+un…@googlegroups.com.



You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.

To post to this group, send email to er…@googlegroups.com.

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


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


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 er...@googlegroups.com.

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

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

 

 

Hi 


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

Thanks
Joseph

On Friday, 14 December 2012 13:01:03 UTC+2, Umair Sayyed wrote:
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

On Fri, Dec 14, 2012 at 4:11 PM, Joseph Siame <th...@gmail.com> wrote:
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

On Friday, 14 December 2012 11:56:46 UTC+2, Umair Sayyed wrote:
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


On Fri, Dec 14, 2012 at 2:29 PM, Joseph Siame <th...@gmail.com> wrote:
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 <th...@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+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+unsubscr…@googlegroups.com.



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+un…@googlegroups.com.


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


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 er...@googlegroups.com.

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

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

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