Header Optional 3


Datafile Software

Header Optional 3

Name Type Description

Work Val (internal) L, K

Default Form X SOP Only. The quick form offered by default on add new order

Deferred Date D, E SOP Only. Used in Header-link Back-2-Back, this is the date to await before purchase order generation.

Supplier Code X SOP Only. Used in Header-link Back-2-Back, this is the supplier to create the purchase order for.

VAT (Tax Excl) L, K Tax Value in POP. Tax value accumulated from order details where price band is VAT exclusive. Needed particularly if using the SOP multiple payment option. Must also specify Tax value item on order detail file — see detail profile below

VAT (Tax Incl) L, K SOP Only. Tax value accumulated from order detail where price band is VAT inclusive. Must also set equivalent field in the order detail file.

Inv Val (Incl VAT) L, K SOP Only. Value of invoices including VAT raised so far.

Omit Item Prices ? If Y, then order acknowledgement documents do not print price

Matrix Exp Date D, E Date at which to valid matrix expiry dates against. If matrix expiry date earlier than this date then matrix entry is not applied. If not referenced the expiry date is validated against the date added.

Matrix Disc Group N, T Discount matrix options allow application based on a customer group based on the accounts file. This option, defaulted to the customer group by copy items, allows amendment of the customer group on an order-by-order basis.

Forward Date D, E Date F-Forward order status should revert to A-Active

Link to Job ? SOP Only. If Y, then sales order is linked to a job record (SOP/JC link accessory). NB: this field is set by the system and should not be input on sales order header screen.

Job Reference X, Y SOP Only. Job code the sales order is linked to (SOP/JC link accessory)

Cost Value L, K SOP Only. Accumulated cost value of order for information

B2B Purchase Order X SOP Only. Used in Header-link Back-2-Back, this is a flag to identify the sales order as requiring purchase order. If blank then no purchase order is generated, if Y then purchase order is awaiting generation, if P then purchase order has been generated, and if D then purchase order has been delivered.

B2B Sales Order X POP Only. Flag set to show purchase order has been created from sales orders (Back-2-Back accessory)

B2B Order Code X On Sales Orders this contains the purchase order created, on purchase orders the sales order reference the purchase order was created for (B2B and header-link)


Custom Fields

Article ID: 1572
Created On: Wed, Jul 4, 2012 at 10:59 AM
Last Updated On: Mon, Jun 12, 2023 at 4:52 PM

Online URL: https://kb.datafile.co.uk/article/header-optional-3-1572.html