Settings in Invoicing manage the default settings when creating a new sales order, quote or sales order credit note.
The important system settings in Invoicing are:
ID Key | Default | Description |
---|---|---|
DefaultInvoice | Wholesale | Default sales order type on creation of
a new sales order. The invoice type, under WST mode, determined
the calculation of sales tax. Under GST mode, the only use is to
control sales order report printing. |
InvoiceTypeDescription1 | Tax Exclusive | Editable description For Wholesale Invoice Type. |
InvoiceTypeDescription2 | Tax Inclusive | Editable description For Retail Invoice Type. |
AllowInvoiceTypeChange | Yes | Allow invoice type selection from list box on creation of a new sales order. The invoice type cannot be changed once a sales order has been saved. |
DefaultBillType | Ship & Bill | The billing type of the invoice determines
when invoicing and deliveries occur. Billing type can be changed
at any time until the first snapshot has been processed. Changing
to Ship Complete will prompt: “Changing the Billing Type will automatically
save the sales order. Do you want to proceed?”For
example Snapshot 2 – deliveries and invoice for 2,500
Snapshot 1 – no deliveries and no invoice Ship CompleteSnapshot 2 - goods for 1,500 are delivered and customer is invoiced for 2,500 Snapshot – goods for 1,000 are delivered BUT customer is NOT invoiced Bill CompleteSnapshot 2 - goods are delivered and customer is invoiced for 1,500 Snapshot – goods are delivered and customer is invoiced for 1,000 Ship & BillSnapshot 2 - $1,500 Snapshot 1 – $1,000 |
AllowBillingTypeChange | Yes | Allow billing type selection from list box |
DefaultDocumentType | Invoice | Document type determines whether the sales
order can be processed. Only type Invoice can be processed.
A message will display when attempting to process an Order from
the form – “Unable to process due to the following reason – Cannot
process an order” Orders do not appear in the list when processing
from the menu. |
DefaultBOMode | Automatic | Back order mode controls whether back
orders are delivered on subsequent snapshots via Process Back Orders (automatic)
or via manual creation of a snapshot (manual). Manual back order
mode can also be used to force stock onto back order where you don’t
want to deliver stock. Back order mode can then be set to Automatic
if required. |
BranchInvoicing | No | Facilitates branch/sales division selection on a sales order. Branch/sales division details are set up in System, Branch Config. Branch/sales division can be extended to the General Ledger where the BranchSegNo is set in Ledger. Specific ledger details are also set in the Branch Config form. |
UseInventorySalesLedgers | Yes | Where set to Yes, the sales value posts to the Sales ledger account from the inventory record, OTHERWISE the sales value posts to the Debtor Sales ledger account from the debtor record. |
DefaultSalesPerson | Yes | Automatically attribute sales to the default
staff member from the debtor record. Another name can be selected
from the search window attached to the field Staff. |
UsePicking | No | Displays an additional column in the sales
order grid that requires a box to be checked for each line with a delivery
before the sales order is available for processing. |
DefaultQuantity | 1 | Default ordered quantity displayed on a sales order when adding a new part number to the grid. |
AllowPricedOverride | Yes | Allow manual price over-rides on selling price. |
AllowTaxRateOverrides | Yes | Permit tax rates to be changed. |
AllowInvoiceNumber Override |
Yes | Generate Invoice numbers manually or automatically.
Where automatically generated, then a local Jiwa.xml setting permits more
than one invoice numbering sequence to be operating <InvoicingParams> <IncrementInvoiceNumbers>Central</IncrementInvoiceNumbers> |
CheckForDuplicateOrderNos | Yes | Checks for duplicate order numbers for
that debtor and displays an error message.
with the option to preview existing sales orders with the same (debtor)
Order Number |
DocketNumHeader | D | The prefix preceding each snapshot number – i.e. 0593-D01 |
CreditNoteHeader | Pre-fix, if required to indicate the form is a credit note – i.e. C059 | |
AllowAlternateDescriptions | Description field is editable | Allows the inventory description to be
manually edited or selected from a search window from data entered in
the Other Descriptions field displayed in the Other tab
of the inventory record. |
AllowManualPartNoEntry | Yes | Opens the field Part No in the sales order grid for manual entry of part numbers. An invalid part number will display the Inventory search window. |
AllowNonInventoryItems | Yes | Permits the use of Non Inventory items. These items are entered into a sales orders by left clicking the icon and selecting from the drop down list - Insert-Non Inventory Item. |
DefaultExpirySortOrder | DateIn | The default sort order for available serialised/
expiry date stock. Single left click over the column titles in the
serial number dialogue box sorts the data – ascending order |
PostingDateType | No | This specific setting determines the posting
date to the General Ledger and Debtors based on the field SO_History.RecordDate
and works as follows:
The Totals tab displays fields with the appropriate dates for each snapshot i.e. Date Created, Date Last Saved, Date Posted and Date Processed |
AllowInitDateEdit | Yes | Permits the field Initiated to be edited. May impact the updating to the ledger and debtors based on UpdateDateOnSave setting. |
AllowOtherOverrides | No | Enable editing of additional fields in the sales order grid – e.g. RRP, Units, Classification, Category 1, 2 and 3 and Weight. |
MultiBackToBack | Yes | Single back to back sales order to create multiple back to back purchase orders. |
AllowKitComponentOverride | Yes | Permit kit component quantities to be edited |
LineLinks | Contacts | Additional field for selection on a sales
order – either selected from a Jiwa table or user defined table |
LinkSELECT | The SELECT Statement in the Contents cell when the LineLinks is set to UserDefined (Sample: SELECT RECID, Description FROM MY_Table | |
LinkTITLE | Column Header | |
LinkDESC | OrderBy FieldName | |
LinkKEY | OrderBy KeyName (i.e. Description) | |
LinkID | ID FieldName (i.e. RECID) | |
ComponentsForeColour | 255,000,255 | Colour of kit component lines on a sales orders (RED, GREEN, BLUE) |
KitRoundingForceColour | 000,200,000 | Colour of line in sales orders with a kit rounding (RED,GREEN,BLUE) |
NonInventoryForeColour | 000,125,000 | Colour of Non-Inventory lines in sales orders and quotes. (RED,GREEN,BLUE) |
SalesInfoIncludesCreditNotesNot ReturnedToStock |
Yes | Include Credit Notes where the stock was not credited back into inventory |
SalesInfoIncludesTax | Yes | The Sales figures in the Debtors Maintenance and Inventory Maintenance Sales Tab are to include tax. |
UseZeroCreditLimit | No | To apply a credit check and display a
warning message on sales order saving, where the Limit in the Debtors,
Credit tab = 0.00 e.g. Cash Sale Customer. |
SalesInfoExcludesKits | Exclude Headers | Determines the value of kitted inventory
items to be displayed as the Sales figures (Sales Tab in Debtors Maintenance
and Inventory Maintenance) |
AllowSaveToReserveOrderWhen DebtorOnHold |
No | Permit the saving of a new sales order with a Doc Type of ‘Order’ when the debtor is on Hold |
AddFreightToAllSnapshots | No | Add freight to be charged on all snapshots with deliveries – applies to the billing type Ship & Bill only |
BatchGrouping | Normal | Determines how cash book receipt batches
are created / appended to, when sales orders are processed with payment
details entered in the Totals tab of the sales order – i.e. new
batches created based on sales order warehouse or branch |
PostTendered | Yes | Post amount tendered on sales order to debtors as a payment. |
WarnWhenNoPayments | No | Display a message when there are no payments entered in the Total tab of sales order. |
WarnWhenNoPayments Message |
Message to display when no payments are recorded and system setting WarnWhenNoPayments = Yes | |
BuildPaymentReferenceFromDebtor | Yes | Insert banking details from the Debtor Maintenance - Financial Tab into Sales Order Total Tab when payments are entered in the Sales Order Total Tab. |
IncludeValueOfBackOrdersIn CreditLimitCheck |
Yes | Include stock on back order when applying credit limit checks at sales order entry and saving stages. |
KitForeColour | 000,000,255 | Colour of kit header line on a sales orders (RED, GREEN, BLUE) |
PrintWhenSaving | No | Sales order reports to print automatically
on saving. The switch can be used in conjunction with a local setting
in Jiwa.xml [InvoicingParams] <PrintToScreen>0</PrintToScreen> |
ManualPrintSelection | Yes | Display printing selection window when saving |
PrintInvoicesWithZeroQuantityDel | No | Print sales order reports where quantity delivered=0 |
EmailInvoicesWithZeroQuantityDel | No | Email sales order reports where quantity delivered=0 |
AllowModificationOfPrinted UnprocessedInvoicesMessage |
The message that is displayed when permitting
editing of printed unprocessed orders. This switch is used in conjunction
with the local Jiwa.xml setting: <InvoicingParams> |
|
InvoicesFromQuotesUse ActivateDate |
No | Sets the Initiated date of the invoice
created from a quote using the Standard Orders Batch Processing form to
be either the:
|
DefaultQuoteExpiryDays | 30 | Automatic calculation of expiry days for a quote. |
AllowQuoteOverrideMessage | Yes | Allow a message to display when a quote passes the expiry date when the sales order is created from within the Quoting module and not the Standing Orders Batch Processing. |
AllowQuoteNumberOverride | No | Allow manually generated quote numbers |
DefaultPriceUpdating | No | Update quote prices to current pricing on batch activation when converting quotes to sales orders. |
ShowOnlyUsersDebtors | No | Restricts a user to creating and viewing sales orders for only those debtors where the user is attached as a Staff Member in the Main tab of the debtor record. |
DefaultManualSerial Quantity |
Minimum Quantity | The default quantity when using the manual
serial picking system. |
ValidateABN | No | Provides for validation of the debtors ABN when creating the sales order. Only a warning is displayed – the user can continue to enter data. |
UseTaxExemption | No | Displays the Tax Exemption box populated with any data from the debtor record. Any information in this field will recalculate the GST/VAT by applying the first 0.00 rate found in the Supplies tab of the Tax Maintenance form. |
CompensateTaxRounding | Yes | Adjust GST/VAT amounts to compensate for any rounding where line tax calculated does not equal the Total EX GST/VAT * the tax rate. Any tax variation is written into the last line where tax is charged on saving the sales order. |
PostNonPhysicalToCOGS | No | Post Non Physical Items To Inventory Value and COGS. |
UseKitRoundingPart | Yes | Place Rounding differences on kits to the rounding part |
KitRoundingPart | Inventory Item used to absorb Kit rounding. | |
AllowForwardOrders | Yes | Allow Order Type of Forward Order to be used |
AllowActiveOrders | Yes | Allow Order Type of Active Order to be used |
Cartage3ToDebtorInsurance Ledger |
No | When processing the sales order, post the Cartage3 (Freight2) to the Debtors Insurance Ledger (DB_Main2.D11) |
UseDirectTaxIfSellPriceIncTax | No | Tax is direct tax only if the item is SellPriceIncTax. |
DisplayProductUpsellPopup | Yes | Display the product up-sell popup when a product is selected that has up-sell products. |
CustomTABCaption | Custom | This is the label for the custom tab on Sales Order Entry and Quotes. |
DiscountPercentDecimalPlaces | 2 | The number of decimal places the discount percent should be stored in sales orders and quotes. |
DefaultSplitOrders | Yes | When creating a new Sales Order Delivery Line Batch, the Split Orders setting defaults to this value. |
DefaultFlagSalesOrderFor Processing |
Yes | When creating a new Sales Order Delivery Line Batch, the custom setting AutomaticallyProcessThisInvoice is set to this value. |
DefaultSplitBackOrders | Yes | When creating a new Sales Order Delivery Line Batch, the Split Back-Orders setting defaults to this value. |
FindStockIncludesPrinted Invoices |
Yes | The Find Stock function of Sales Orders will include sales orders where the Invoice has been printed. |
FindStockIncludesPrintedDel Docket |
Yes | The Find Stock function of Sales Orders will include sales orders where the Delivery Docket has been printed |
FindStockIncludesPrinted Picksheets |
Yes | The Find Stock function of Sales Orders will include sales orders where the Picking Sheet has been printed |
FindStockIncludesPrinted PackSlip |
Yes | The Find Stock function of Sales Orders will include sales orders where the Packing Slip has been printed |
FindStockIncludesPrintedOther | Yes | The Find Stock function of Sales Orders will include sales orders where the Other print document type has been printed |
BackOrderProcessingFlags InvoicingForProcessing |
No | Back Order Processing will set the AutomaticallyProcessThisInvoiceFlag to TRUE for sales orders where deliveries are made. |
RunSOProcessingAtConclusionOf BOProcessing |
No | Run sales order processing at the conclusion of backorder processing. |
SalesOrderProcesingOnlyIncludes OrdersFlaggedForProcessing |
No | Sales order processing, when run by backorder processing, only processes invoices flagged for processing by the AutomaticallyProcessThisInvoice setting. |
AllowDocumentManipulation OnClosedSalesOrders |
No | Allow Documents to be modified on closed sales orders. |
AllowDocumentManipulationOn ProcessedSalesOrders |
No | Allow Documents to be modified on processed sales orders. |
AllowNoteManipulationOn ProcessedSalesOrders |
No | Allow Notes to be modified on processed sales orders. |
AllowNoteManipulationOnClosed SalesOrders |
No | Allow Notes to be modified on closed sales orders. |
CopySalesOrderIncludes Notes |
No | Copying a salesorder copies Notes over as well. |
CopySalesOrderincludes Documents |
No | Copying a salesorder copies Documents as well. |
CopySalesQuoteincludesNotes | No | Copying a Sales Quote copies Notes as well. |
CopySalesQuoteincludes Documents |
No | Copying a Sales Quote copies Document as well. |
MakeSalesOrderfromQuote includesNotes |
No | Making Sales Order from quotes includes a Note. |
MakeSalesOrderfromQuote includesDocuments |
No | Making Sales Order from quote includes Documents. |
SalesOrderProcesingOnly IncludesDocuments |
No | Sales Order processing when run by Back order processing only processes invoices which still have backorders |
DisplayCustomerSalesHistoryPopUp | Yes | Display the history of product sales for the customer as a pop-up window on the sales order form. |
DisplayProductUpsellPopupHistory | Yes | Display the history of sales for the selected product on the sales order form. |
UseApplicationLocking | No | UseApplicationLocking |
DoNotReadSOHLevels | Yes | Do not read SOH Levels |
DoNotReadSupplierInfo | Yes | Do not read Supplier Information |
CopySalesOrderToNewForm | No | Copy Sales order to a new instance of the form |
AllowInvoiceEmailing | Yes | Allow Invoices to be emailed direct from the sales order form. |
ShowHistoryStatus | No | Display the history status field on the sales order form. |
DontApplyDebtorDiscounts | No | Suppress the discount prices with the debtor discount. |
SalesDelProcessingDontPopulate DefaultRanges |
No | Turn on to force the Sales Order Delivery Batch Processing form to not populate the ranges grid (may help in performance) |
UsePaymentTypeBankAccounts | No | Use the bank account assigned to the payment type when processing sales order payments. When OFF, the system uses the debtor configured bank account. |
ApplyWarehouseMaskToBankAccounts | No | Mask the bank account for the payment with the warehouse mask when processing sales order payments. |
WarnWhenCCPaymentExceeds OrderValue |
No | Warn when making a credit card payment if the payment total exceeds the order total. |
StoredProcForSalesOrderExport | usp_JIWA_Sales Orders_Export |
Name of the stored procedure that is used for exporting Sales Orders. |
SalesOrderMoneyDecimalPlaces | 2 | Number of decimal places for money values |
StoredProcForSalesOrderExportWrite | Name of the stored procedure that is used for exporting Sales Orders - Write connection | |
PostZeroValueInvoiceToDebtors | No | Post zero value invoice transactions to debtors when processing sales orders. |
Copyright © 2012 Jiwa Financials. All rights reserved.