hi everyone!
I am james golla from the philippines. kinda new here. i learned about dataport just recently. everything was going smooth, migrating gen. journal transactions with much ease. however, just this afternoon, i attempted to migrate credit memo. Data was migrated successfully, except that when i was trying to post them, an error message says ‘there’s no customer ledger entries within the filter’. So i checked if the invoices i indicated in “applies-to doc. no.” column exist, i clicked assist button. i found out, there really is such a doc number. my question is, is this error a result of ‘dataporting’ without validating applies-to doc. no? if yes, can someone help me write the c/al validation? honeslty, i have still no idea about c/al.
Thanks,
james
Hi James,
The “Applies-to Doc No.” field is being used when posting Credit Memos to assign a certain invoice which should be settled when the credit memo is posted. So after successful posting (given that invoice and credit memo do have the same amount) none of the posted documents remain open.
So if your invoice is not open anymore (because already paid) and you are still trying to apply the credit memo to that invoice you will face the error described.
But you should definitely consider to run the validation code (call the VALIDATE) especially for the “Applies-to Doc. No.” field.
If you are not sure that you can omit the VALIDATE of a field, the call it.
This way you can emulate the same behavior as the user would cause when cresting the credit memo manually.