Hi,
what are the absolut minimum requirements to get from an empty system via an order to a Datev-Export considering order related amount is paid?
I would love to understand the mandatory baseline and build eror reports based on it to identify masterdata gap’s. More relevant are for me database tables & columns, anyhow I also want to keep it readabe for users.
I will start with my understanding and would update by all comments I receive on that, will also add all according columns:
A) Preparation
B) Movement data
A) Preparation (x Window - database table - database column = comment)
x Organisation ad_org
- isactive = yes
- name
x Payment Term (check, ideally existing can be used)
- Name
- isactive
- organizaton
x Price system
- isactive
- org_id
- name
x tax category (check, ideally existing can be used)
- isactive
- org_id
- name
x product category
- isactive
- org_id
- name
x bank account
- isactive
- org_id
- IBAN
x Price list
- isactive
- org_id
- pricing system
- currency
XX Price list- price list version
- isactive
- org_id
- valid from
x Payment term
- isactive = yes
- org_id
- name
x Business Partner c_bpartner
- isactive = yes
- org_id
- c_paymentterm_ID = payment term in bpartner window
- m_pricingsystem_id = price system in Bisinesspartner created
- bank account
xx Business Partner - tab location - isactive = yes
- country
x Product
- isactive = yes
- org_id
- issold = for sales orders
- ispurch = for purchase order
xx product - Price --> Bpartner price = price for this product - isactive = yes
- org_id
- tax category
xx Product Tab BPartner
-isactive - org
- bpartner
B) Movement data
x m_order (sales order or purchase order, different windows but same table, differentiator “issotrx” = Y/N
- bpartner
- pricing system
- organization
- status co = completed
xx order - orderline
- product
- quantity
- price
Not clear for me:
material receipt candidates / material receipt, is it mandatory?
x invoice window purchase invoice/ sales invoice
- allocation to order
- status co = complete
x payment
- bparner
- doctype
- docstatus co = complete
- bpartner bank account
- order id / or invoice ID
- org id
x accounting export for export of data
- Table Fact_acct
x for export of documents