Hi,
I am trying to post a cash discount journal.
For that I have a account structure of Main 520200(Vendor cash discount account) - Dept (all+blank allowed) - Vendor (all + blank allowed)
I posted an AP invoice journal with cash discount amount.
Then I went to payment journal and selected the invoice to be settled (Functions → Settlements) and posted the payment journal and it got posted.
When I view Payment Journal (lines) → Inquiries → Voucher -->Related Voucher → Voucher (button),
the ledger account field is showing only 520200-- instead of 520200-dept-vendor (00000004)
Payment Journal (lines) → Buttons → financial dimensions → Account is entirely blank.
This is an end user issue and needs to be solved fast.
Any ideas why the system is not throwing an error and simply posting to the main account (520200) alone.
Thanks,
Lakshmi
Hi Lakshmi
Few reasons for your issue could be:-
a. There are no default dimensions on vendor main form. Because, normally in any transactions when you select vendor dimensions assigned will default on transaction lines. Verify again after setting up these.
b. Why system has not thrown any error :- is because in account structure its setup as ‘allow blank’, hence system will not mandate to have dimension on lines.
Hope this clarifies your issue. Let me know if still exists.
Thanks
Srinivas
Hi Shrinivas,
Here is the account structure setup. I did activate it later.
Also I did update financial dimensions of vendor.
Even then financial dimensions doesn’t appear correctly and no error pops up.
Please let me know if I have to check anymore settings.
I am also going through debugging stuff. I first wanted to check if the dimensions are getting updated properly in LedgerJournalTrans. In this table, there are two fields ledger dimension and defaultdimension and both are updated by RecId. When I further dig into their main tables, even their main tables are filled with references (DimenisonAttributeValueSet, DimensionAttributeValueCombnation).
So any idea where I can view the financial dimensions to make sure the right dimensions got updated.?
Thanks,
Lakshmi
Sorry in previous post, I updated a wrong snapshot for vendor info.
Thanks,
Lakshmi
Sorry In previous post, I updated a wrong snapshot for vendor info. Here is the correct one
.
Thanks,
Lakshmi
Hi Lakshmi
Follow the below steps and refer to screen shots which i managed to create cash discount entry and get it right.
a. Setup default dimension on vendor master
b. Setup appropriate account structure
c. Post invoice journal – while posting journal verify whether default dimensions populated onto vendor and same are updated to offset account also. Verify whether cash discount code is selected or defaulted from vendor.
d. Verify invoice postings whether Debit entry is posted with dimension.
e. Post payment journal and verify related vouchers- discount value should be posted discount account along with dimension.
Pls. refer to screens.
Srinivas
Hi Shrinivas,
Please explain me in detailed way as I am new to this task.
Account structure and default dimensions of vendor master are set properly.
While creating an invoice journal, financial dimensions are automatically populated from vendor master.
Did you manually set the offset account or did it automatically got populated with cash discount account - dept -?
For me, it is not automatically populating. I just selected a bank -operating account. If the offset account has to be automatically populated, please navigate me how to do the setup for it.
While posting the system is taking cash discount account from cash discount setup (520200 - -) but is not posting to (520200 -10-00000003) (i.e. not considering the dimensions from vendor master or dimensions populated into the invoice journal.
please naviagate me to the path where I can verify the financial dimensions of the Debit entry of the invoice posting.
thanks in advance,
lakshmi
.
HI Shrinivas,
Looks like the problem has got side-tracked. The account structure says main account - dept (no blanks allowed) - vendor (no blanks allowed) is the structure for posting AP Cash discounts.
End user forgot to provide dept and vendor in financial dimensions. So basically the system must throw an error while posting the journal because dept and vendor dimensions are not provided. Instead system posted the journal.
That was the reason for starting this thread. I did realize I provided wrong offset account value to the invoice journal. But even though I provide the correct Cash Discount Main account; as dept and vendor dimensions are not provided system must throw the error rather than posting to 520200 - -. We are able to replicate the error also.
Hope we both understand the problem in the same way. So some where system is not doing the offset account validation properly.
That needs to be rectified.
Thanks,
Lakshmi
Hi Lakshmi
Can you post all your transaction screen shots step by step along with setup of account structure, invoice journal, dimension defaulting on vendor account in invoice journal form, payment journal and posting of invoice journal vouchers and payment journal vouchers etc., this will help me in understanding issue more clearly.
Srinivas
Hi Shrinivas,
just a quick question
End user from a department (main account -141500) is posting an invoice journal. Since he settled transactions on time, he got a cash discount.
So first end user posted an invoice journal for offset account (141500). Now end user is trying to do settlement using payment journal. Now in this process, system automatically posts cash discount. but where should end user provide the additional financial dimensions of the cash discounts?
Thanks,
Lakshmi
He need not to provide anywhere in transactions. Dimension validation system anyways validates through account structure.
You have to make sure while posting invoice journal required dimensions are selected in main & offset account.
During settlement through payment journal, system will update respective dimension to discount voucher lines also.
Srinivas
