How to set up 'Doc. Date' as the date we post the Journal Entry/Invoice?
In SAP Business One 2007A, the Journal Entry / Invoice have 'Doc. Date' automatically equals to ''Posting Date'.
Is there any way to have 'Doc. Date' as the date we post the invoice?
one invoice has:
Posting date: Mar 31, 2009
Due date: Apr 30, 2009
We posted the invoice to SAP on May 18, 2009. We'd like SAP to show 'Doc. Date' automatically as the date when we do the positng. Thanks!
Ajay Audich replied
Wish that you had mentioned the job costing import in your orginal question. Anyways, this is how you might want to proceed:
1. If the support team for your job costing system can change the code so as to map the doc date field as the system date - that will be one option.
2. If Option-1 is either not possible or an expensive option then try and put the formatted search anyways as suggested in earlier email. Then when the records are imported from your job costing module to SAP, the formatted search should automatically be triggered and you should get the doc date as system date.
Hope this helps,