Sales Ledger Requirements

 

Capabilities Required: Sales Ledger

 

Area

Capabilities

Functionality

Priority

Generate Pseudo invoice(s)

For clients who require pseudo invoices, these need to be generated and despatched ahead of the accounting package

Future state must support this

Exists

Essential

Provide invoice data to accounts system

Ability to release invoiceable data information to accounts package.

this information is known per business type - so not listed in detail here

But in summary:-

Orders - all invoiceable elements (origination, garments, processing, despatch

Storage  - total storage charge

Webstore  - all invoiceable elements

Purchase Orders - handling fees

Decorated processing services - all captured on PO ?

Currently this is based on invoice status and then batch scheduled overnight

Any appetite for a real time push basis?

Communication confirmation - i.e. successful handshake of information

Ability to resend invoice information if needed

 

What about standalone services - e.g. art services

 

Exists

Essential

Regenerate Invoice Data

Need some ability to force recalculation of invoice data

Research case studies, but in essence

 

Qty amends - should refresh the calculation of Total

Price corrections  - again force recalculation

 

This should be a restricted access function

 

 

Correct Data

Ability to update / edit/ add invoice data

 

There needs to be the ability to for staff to edit / add invoice related data where it is incorrect or missing

 

Exists

Essential

Audit

provide audit trail of any user changes to invoice data

This to have dual purpose

  - control of changes made and by whom

 - MIS for upstream issues (technical and/or operational) that

 

 

Support Storage Charges

Ability to calculate storage charges and create invoiceable data

Exists

Essential

Generate Invoice supporting reports / documentation

Ability to generate supporting reports for invoicing

Storage Charges

Webstore charges

Handling Charges

Decorated services

Exists

Essential

Provide Invoice Information to Portal

Provide capability that all invoice(s) together with supporting reports are exposed to the portal for clients to see / download

Enhancement

High

Provide Finance Data to Portal

Provide finance data to portal

 - Balance

 - Aged breakdown

 - Credit Limit (new)

Exists & Enhancement

High

Generation and communication of invoices

Proposal to continue to generate and communicate this information from accounting package  

Exists

Essential

Client Payment Processing

Proposal to continue to record payment receipts (and allocate to open invoices)  direct in accounts package

Exists

Essential

Remittance Generation

Proposal to continue existing working practice of doing in accounting package

Exists

Essential

Bank reconciliation

Proposal to continue existing working practice of reconciling bank balance within accounting package

Exists

Essential

 

 

Inputs

From

Details

Production system

Job Order Invoice able Sales Data

Despatch department

Despatch invoice able charges

Goods In Dept

3rd Party Purchase Order Handling charges

Picking Charges if applicable

Decoration Dept

Charges for processing decorated goods received

These are captured as Purchase Order charges

Warehouse

Client Storage / stock check  charges

Webstore

Web order fulfilment charges (production , garment, packing and despatch)

Bank

Balance and transaction records

Client

Remittance for invoices

 

Outputs

To

Details

Accounts Package

Sales (Invoice able) Data

Clients

Invoice(s)

Statements ; Balance Data

Client Portal

Exposure of Invoices; Client Balance