Purchase Ledger Requirements

Capabilities Required: Purchase Ledger

 

Area

Capabilities

Functionality

Priority

Receive Supplier Invoice

Currently  email receipt outside of production system.

Proposal is to continue this outside production system

N/A

N/A

Reconcile Supplier invoice <--> Internal PO record

This is a manual process that requires access to PO's in production system

 

Is there any way of automating this - ?? -I suspect not easily

Exists

Essential

Resolve discrepancies between supplier and Internal PO

Ability to amend internal PO record if incorrect

Exists

Essential

Mark Internal PO's as checked for invoice

Ability to denote that internal PO is invoice checked

Exists

Essential

Load supplier invoice to accounts package

This is currently done manually in the accounts package

There are add ons that can automatically read / create / invoice records into Sage (Autoentry)

It would be worthwhile exploring to see what the cost / benefit of this would be

Accounting package enhancement ?

High

Generate Payment of invoice amount within Sage

Handled within the accounts package

Proposal to retain this

 

Open question: If supplier invoices were only sent to Sage once reconciled - does it make sense to automate their capture / ledger entries and release for payment ?

 

Accounting package enhancement ?

High

Generate Payment advice (remittance) to suppliers

Handled within the accounts package

Proposal to retain this

N/A

N/A

Send payment instruction to Bank

Handled within the accounts package

Proposal to retain this

N/A

N/A

Reconcile Bank post supplier payments

Handled within the accounts package

Proposal to retain this

N/A

N/A

Gaps

 

 

 

Purchase Orders in Production system

Is there any benefit in extracting these into the accounts package

 

Assumption is no as until goods supplied and supplier invoice received, there is no accounting activity

 

 

Is there a need to know the @sum of open PO's that are not yet "actualised" , i.e. not yet invoiced by supplier

 

In theory these are on the accounts payable side of the balance sheet - but question is whether this needs to be captured or not ?

 

 

 

 

Inputs

From

Details

Supplier

Invoice for services provided to TOT

Internal Production system

PO record information for (some) supplier services

Bank

Transaction / Balance Data

 

Outputs

To

Details

Bank

Payment Instructions

Supplier

Invoice remittance

Internal Production system

PO record status update

 

 

See here for workflow schematic