2010 Jul 06 7:25 PM
Hi all,
Has anybody had to migrate items that were already written off? I know it's not standard practice and am having a hard time finding any references how to do this.
I tried creating a custom object in Emigall using BDC of FP04, and couldn't get that to import.
So I thought maybe it could be done simply by manipulating the Document object.
I've tried sending in 2 documents, one with the original charges, and the write-off with a reference document of the original charges. Problem there is they both end up with clearing restriction of "T" (External interface clearing), so automatic clearing won't be allowed.
Then I tried sending the write-off document first, sending the original document second with the reference document of the write-off document, and the clearing fields (clearing status, date, duciument, reason, currency, amount, restriction) set to what I wanted them to be. The clearing restriction is blank now (which is what I want) but the item did not clear like I expected it to.
If anybody has any suggestions on how to go about doing this, I would appreciate it!
Thanks
CN
2010 Jul 07 4:15 PM
CN:
The required approach here would be to migrate the documents as open items. Set them into specific document types or some identifying characteristic - then use that identifier in an FP04M run following the migration. You might then need to do a journal entry so that the GL does not account for the writeoffs twice.
regards,
bill.
2010 Jul 07 4:15 PM
CN:
The required approach here would be to migrate the documents as open items. Set them into specific document types or some identifying characteristic - then use that identifier in an FP04M run following the migration. You might then need to do a journal entry so that the GL does not account for the writeoffs twice.
regards,
bill.
2010 Jul 07 6:50 PM
I was suspecting we'd end up needing to do that. Thanks Bill for confirming that!