This will be the remark from Pieter Valentijn

External id's

External id's [Pieter] This is used to find the correct record and to see if the item exsist. Thus it should be a good way to identify the records from osC to osF. The idea for multyshop is to prefix the recordsid. Thats why its a string and not a number.

[Carine] OK, I've seen the external id in action now, that is working fine.

BTW

Uitgaande handelingen

[Pieter] I see you use the dochead and docline. You will miss all batch entered stuff that way. Its beter to use the transact table that holds all transactions. All do this is a good way to see the unprocessed to i think its probably better to write it on the transact as even simple bank / cash set of books will be able to use the report.

[Carine] I agree. I realized afterwards that this is not the good way to go about this, but as a habit in our accounting we always use documents when booking something with taxes. So I think my system is safe for me to work with, but I'd need to put sometime in to get a better version using the transact tables just as you say.