Question

To automate the sales system in Excel, what are processing tasks that could be automatically performed when an invoice is accepted?

Answer 1

Question:

To automate the sales system in Excel, what are processing tasks that could be automatically performed when an invoice is accepted?

Answer:

To automate the sales system in Excel, there can be following processing task which can be automaticlly performed when an invoice is accepted:

Tasks:

Fill a column with a series of numbers

1. Select the first cell in the range that you want to fill.
2. Type the starting value for the series.
3. Type a value in the next cell to establish a pattern. ...
4. Select the cells that contain the starting values. ...
5. Drag the fill handle across the range that you want to fill.

These task may have the follwing objectives to be accomplished for automate the sales system.

(1) Invoice Posting to Customer's Account,

(2) Invoice Posting in Inventory Account (Finished Goods Stock)

(3) Invoice Posting to Sales Tax Account

(4) Gate Pass generation for despatch outside the factory gate

(5) Packing & Despatch Instructions

(6) Invoice copy for Accounts & Collection Cell