Daily Sales Invoice report - Accounts Receivable Account incorrect data used

[bkm888]

When running the new Daily Sales Invoice report, the "Accounts Receivable Account" column is currently being populated with the Account header name form the ERPNext chart of accounts (Debtors - MSD). The instructions for this column were to force the value to always be "11000"

The external accounting program that is receiving the output of this report cannot parse the account header names of the ERPNext chart of accounts. It is also not appropriate for us to change the current chart of accounts to match the external program. We use the ERPNext chart of accounts in other places already.

Please force the data for this column to be the account number 11000

[ghost]

@bkm888 As you requested in the mail, 'Accounts receivable' column should have the account number of the debit account. We have done the same in the report, wherein if you put 'Account Number' in your 'Account' it will show up in the report the way you require it to be.

Account number in the account:

This is how it will appear in the report:

To keep it update friendly, instead of hard-coding the value we have fetched the 'Account Number' from the debit account for 'Accounts Receivable' and its same for 'G/L account' wrt to line item being 'Item' or 'Tax'.

[bkm888]

In our version of ERPNext we elected to use the standard chart of accounts. There is no account number field visible on the account screen. See below:

Is it still safe to click on the "Update Account Number" button if we elecetd the standart chart of accounts?

BKM

[ghost]

@bkm888 Yes, it is safe to update the account number. You can 'Update Account Number' and put your account number. This updated account number will be fetched in the report without having to hard-code it. In your case, it will be '11000' for accounts receivable, and '40200' or '23100' for respective G/L account.