Connection to Phreedom erp

[Alvin]

This script will run standalone and post to zc database, however in
the end a script will post sales date to Phreedom erp.

It may be necessary to consider what needs to post to erp when planing
this script.

Sale data to Post

1. Customer id
2. Bill to, Ship to
3. Date
4. Currency
5. Store, branch, or location id
6. Item data: Qty, sku, Description, Price, Discount, Tax
7. GL accounts: Cash account, Income account, Inventory account, tax
payable account, cost of sales account, Note: All these accounts will
be different of each location.

I am not sure how to do this? I looked for a zc addon for multiple
warehouse management and did not find much. Maybe we need a simple
addon for zc that would grab inventory location data from erp and and
display it. We would use the new table in zc to work with POS. This
would mean that if you use POS for multiple location, you would need
to install this addon... We want to make this system open to as many
users as possible. Keeping in mind that this POS from multi location,
not shipping from multi location.

Please let me know what you think?

[vikas sheokand]

Hi alvin,

I am looking to hear back from you....

Highly Thanks

[Alvin]

Hello Vikas,

When we post to erp, we need to post to some GL accounts... the script
that syncs zc with erp will do this. You had mentioned that you
looked at that script... we will deal with it later. We only want to
take this into account for planing the pos script.

Here are the GL Accounts

Cash account:
Income account:
Inventory account:
tax payable account:
cost of sales account:

These GL posting accounts should be set to default to accounts
that are specific to the location making the sale or a customer (Cash
Sale Rio) that is used for all the regular sales for that location.

This may need to be part of the zc-erp module, I am not sure what sale
data is now stored in zc.

POS script should have these features:

Currency> default to setting in customer.
Customer ID> default and auto fill to a preset customer, "Cash
Sale"
Sales Tax> default to Tax Rate set to Customer.
Payment Method> In more then one currency, calculate (more amount
due) or (change back).
Till Reconciliation> Open till, count currency, Close till, count
currency.
Lay Away> Process a lay away.
Quantity discounts> support quantity discounts in zc
Multi location> I could not find a multi shipping warehouse module
for zc. We will need to deal with multi location for zc.

Keep in mind this script will run standalone with a local install of
zc, some small sync scripts will post and sync data to the hosted zc
database and update the local zc db and folders with update items and
prices.

So we have

local, POS script writing to local zc,
local zc sync and post to hosted zc,
hosted zc post to erp

Because pos script works with zc this way, someone can use it for a
hosted, one location zc.

Please let me know if there is enough here to help put a plan
together?

Alvin

[Alvin]

In addition to this (below) we need to consider the transactions of
Cash paid out, and Cash paid in, to the till, transactions that are
not a sale but part of Cash Management.

Vikas, I am not sure how is the best way to do this? We may need to
make more of a Till management module for zc. We can start with a
simple POS script, but in the end we will need to manage cash at the
till.

Please let me know what you think?

Alvin