Cash entry question

[GaryPanic]

well thats what throw me -
I have a cash table - that has to be seperate otherwise my table is getting bigger than it should - and i already need to trim this down as I have deviated from normlisation -(I know- but I have already tided this up as part of my end excercise so its just a polishing excercise) and my settled system uses the main table to-I had very little duplication (only PK and FK)
the cash then tied to the invoice and worked hunky dorie -

however part payments caused chaos -

the solution of a middle table between them with due and how much had been paid -seems a deviation from the norm - but as its accounts -then anything is possible -
next question would be do I use append when invociing or .add (?)

 

[Simon_MT]

There is an alternative somewhere inbetween:

You can have an Adjustments system as well as Cash Receipts to handle all your miscellaneous transactions. Debtors are no problem except where the payment currency is different to the billing currency and it helps to add base currency i.e. local currency to both Sales and Receipts.

Sage would not accept imports in multiple currencies!

Simon

 

[GaryPanic]

There is an alternative somewhere inbetween:

You can have an Adjustments system as well as Cash Receipts to handle all your miscellaneous transactions. Debtors are no problem except where the payment currency is different to the billing currency and it helps to add base currency i.e. local currency to both Sales and Receipts.

Sage would not accept imports in multiple currencies!

Simon

Ah Simon if it was that simple ...
multi currency some fixed some floating ....
So far
GBP-Eur-USD-AUS=SA Rands- Oman Rands..chocolate buttons.you name it I will probably need it . I need the flexibility (these currecnies problems I knew from the start and have resolved )

GBP/Eur/USD/AUS are fixed not floating - everthing else is all over the place -
this isn't a problem- at settlement stage I have a currecy convertor that changes the exchange rate to what has been recieved - the auditors are happy with this and signed off on it

 

[GaryPanic]

well for the sake of easy/good house keeping I am going to have a sepearate table
this will have invocie/accno /currecny/amount due all locked
then amountpaid and another locked field of due-paid = outstanding and one extra field status o/s part and settled
anything else ?

I will have a look up by invocie number and also a filter by account no
the invocie will show 1 result the filter by account no will show all by account
I think that should do it

then once totally paid the invocie will need to be settled off

statemernt will need to run from this table
handshake into the account table

For once my issue has been a proper one rather than a hash-job

what I might do is put the table together and zip it up for everyone to remark on ?

 

[gemma-the-husky]

you are in danger of reinventing the wheel here

I would not really envisage trying to develop a Sales Ledger - just use Sage for instance - its got all the SL facilities you would need, for a few hundred pounds.
It will cost you far more to develop a less comprehensive ledger. Unless there is a special requirement, I really wouldnt bother.

you can easily produce a transactions file (invoice list) form your SOP system that will import into Sage - you dont need any Sage Developer licences for that.

With Sage, you cant import invoice details that way , just the invoice total - but it works fine.

 

[GaryPanic]

I am too removed from the actual accounts department to know what they use - I know that for market payments they use SSP (Sector) and I can reproduce the end figures to match what they already have ..
I have the cashtable set up - is quite simple - and I knw that they will add to it .

so I will be back ...ahh well its never boring