Hi, I wonder if field 17130 Document Date in table 379 Detailed Cust. Ledg. Entry is of some use. Because I always find it empty no matter how many entries I posted. I was thinking that the report 116 Customer Statement should be based on Document Date instead of Posting Date. I was trying to add option in the report so that user can choose to base on either Posting Date or Document Date. And the statement entries are generated by Detailed Cust. Leg. Entry DataItem. I added a field in table 379 to lookup Document Date on table 21 Cust. Ledger Entry. And it works just fine, I am able to customize report 116 to optionally base the date on the flowfield. However, there is a limitation in which there is no way to add a key that includes such flowfield. A key is required so that the report can be sorted based on Document Date. I am wondering why field 17130 in table 379 is always empty. Is this a bug? Because if I press F1 for help, it says that the field is filled with Document Date from journal line or orders. If only this field contains actual posted data, then there shall not be problem customizing report 116. Anyone … please advice. Thank you. Regards, Hadi Lai
What version are you using? Because in 4.0 and 3.7 the field no longer exists. Also you can’t sort on a flowfield. I would create a new field and add code to populate the field during posting and so you can create a new key for sorting, and as well write a routine to update the historical data. The reason for the new field is because that field gets deleted when you upgrade.
The fact that Document Date is field no. 17130 gives it away as being a localization for the Singapore version. If the field doesn’t seem to behave as described in the help file, you could maybe try to contact your local Microsoft office in order to find out what’s up. Actually, the Portuguese version also sports the same field (no. 13301 in this case).
That’s what I am thinking. creating a new field and adding in codes to fill in the document dates during posting seems to be the only way. However, I want to find out what’s exactly the existing field is for. But does the field 13301 for Portuguese version work fine? Is Document Date posted into this field? I really think Document Date should be copied during posting in addition to Posting Date. Anyway, thanks for your information guys.
Yes, the Document Date field in the portuguese version does get filled in whenever you post something. Do not discard the possibility that there might be a bug in the Singapore version, that’s why contacting Microsoft is a good option. Either a bug or the help file is incorrect.