baandude
17th May 2004, 16:00
Hello,


We are importing sales invoices and credit notes using exchange, but have come across a problem regarding credit notes. Both are using unique transaction types S01 and S02, defined as sales invoices, and credit notes, respectively.

Sales invoices have been setup with the original invoice number, thus no need for the baan document numbers. No problem importing sales invoices. Credit notes however, have been setup with document numbers. Upon importing they are populating tables tfacr400 and 401.

When we post the invoices, am getting error message
"Statement Layout not found". Any clues why this could be occuring?

jzgv01
14th July 2004, 01:19
Does your customer has the statement method, this field is mandatory for the standard procedure of customer statement.
Regards

fmorais
14th July 2004, 17:26
Hi,
The problem seems to arrise from the fact that Baan is unable to generate the new number. So you must generate it yourself writing in table tfgld018 and tfgld017 besides tfacr400 and 401.
Hope this will work,
Regards,
Pedro

Baanboozeled
14th July 2004, 20:46
If you have access to source code, You may get insight from looking at 'Import Journal Vouchers' session tfgld2215m000. There is also an exchange scheme used befor this session is run. JVIMPRT. Look at the associated batches to see how they handle getting the transactions into temporary baan tables. Then check the session script to see how they use baan functions to generate the transaction document numbers, fill the appropriate tables etc...
Cheers,
bb