From new system to accounting / tax consultant


#1

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