0

How to Create a Direct Invoice Inventory?

What is Sales Invoice?

What is Sales Invoice? How to create an Invoice without a Sales Order? In the business world, most of the Invoices or Billing happens as the Customer purchases or buys items (A walk-in customer). It is a cash payment and Credit Receipt process. This is called Direct Invoice Inventory as it is for the items that are sold over the counter (OTC).

However in Business, it happens where the Buyer will call the Seller offering a price to buy items NOW and he will not send a Purchase Order. Seller will Create an Invoice and send materials directly. This Order is called “Over the Phone” and no Sales Orders are made for this as its a confirmed order to deliver.

In ACTouch ERP, we can also create an Invoice without any Sales Order references. This is called “Direct Invoice Inventory”. Here also you can make 2 types of Invoices.

  1. Direct Invoice Inventory
  2. Direct Invoice Services

Video – How to create a Direct Invoice – Inventory?

The Direct Invoice Inventory data entry is same as that of Sales Order Menu. However there are few points to note.

As per the statutory rules, Invoice is a Financial document thats considered for the Confirmation of Sales, Taxes to Collect and customer is liable to PAY the money. It also acts like Stocks or Services is Received by a CUSTOMER and he is agreed to pay the money as per this Invoice.

When you create a Sales Invoice – Inventory, the below activities happens and these are very important to understand.

  1. Sold Items reduces from Inventory / Location where the stock is maintained.
  2. It creates a Liability towards the Customer to PAY MONEY.
  3. It creates an Entry towards TAXes and how much TAX to collect from customer and pay Govt.
  4. It updates the company Balance Sheet, Profit and Loss Data automatically.

Note: ACTouch ERP doesn’t allow you to sell the Items, if the stock is ZERO. Means, we do not allow -ve stock sales. So you need to have stock / Inventory to complete the sales.

Direct Invoice Inventory – Home page has few data that we need enter.

The details are as below.

Field IDField NameMandatory?Field Description and how it helps?
Site IDBranch NameNoIf you are using Multiple Branches feature then this FIELD appears. Multi Branch / Sites is a feature that can help to make separate document for each SITE / Branches.
Invoice NumberInvoice NoYesThis is the Invoice number, a unique number to recognise the document. This is either auto generatedManually you can create.
Credit termsCredit PeriodNoSelect the Credit terms from the Dropdown.
INVOICE DateINVOICE creation DateYesEffective Date of transaction
INVOICE CurrencyCurrency of DocumentYesIt is the currency used for INVOICE Document / for Transaction. This is also called “Document Currency”.
Due DatePayment due dateYesThis is the date by which the payment has to be made.  
Customer IDCustomer IDYesIt is a unique identification number given to each Customer in ACTouch ERP
Customer NameCustomer / Party NameYesCustomer Name / Business name.
Ship ToShipping AddressYesThis is the address of the customer where the particular product has to be delivered to.
GST Number / TAX IDCustomer Tax IDNoThis gives Customer TAX NO. It’s a unique ID necessary for businesses.
PAN NumberPermanent Account NumberNoThis is the Permanent Account Number of the individual / Business.
TCS TaxTax Collected at Source AmountDefault value = NEnable the feature, if you need it. This is the tax payable by a seller, which he collects from the buyer at the time of sale.
Purchase Order referencePurchase/sales order numberNoThis is Customer’s Order Number (for reference)
Purchase Order AmountPurchase order amountNoThis is the total amount of the Customer Order (for reference)  
Purchase Order DatePurchase order dateNoThis is the Customer Order Date (for reference)

Product / Items line details are entered as below. If you update the PRODUCT master with TAXES, HSN Code, Bar Code etc, the data would appear immediately as you CHOOSE a PRODUCT.

Field Details are explained here.

Field IDField NameMandatory?Field Description and how it helps?
Product Group, Subgroup1, Subgroup2, Subgroup3.Product Group, Subgroup1, Subgroup2, Subgroup3 drop down values.NOThese are the data helps to select the right PRODUCT for the line item.   These data appears on the screen, if you enable “Product Group = Yes” in the “Sales Settings”.
Product IDProduct IDYesSelect Product ID for Sales.
Product DescriptionProduct DescriptionYesIt is the description about the product.
UOMUnit Of MeasureYesUnit of Measurement of the Product. If you have an Alternate UOM, then select the same here for the Product that you are selling.
QuantityQuantity MeasureYesThis is the Selling quantity
Unit PriceUnit PriceYesIt is the Unit price of the product.
DiscountDiscount on LINE levelNoApply the PRODUCT level DISCOUNT for the Customer, if any.
Tax incl.Inclusive of TaxDefault = NoTax include – Yes or No. This feature is used for the MRP types of Products where the TAX is ADDED with UNIT price. So we should show the Basic Product Amount + Taxes Separately.
Tax amountTax AmountNoPlease select the TAX CODES that are RIGHT for the PRODUCT. If you have setup these data in Product Master, then ERP will pick from there directly.
TotalTotal AmountYesThis is the Total amount of the line item excluding TAX AMOUNT
HSN CodeHSN CodesNoHSN Codes for the Product that are provided by Government.
Bar CodesBar code NoNoBar codes helps to pick the items from master.

Direct Invoice Inventory – This is the financial portion of the Invoice.

Direct Invoice Inventory – Financial details and its fields are explained below.

Field IDField NameMandatory?Field Description and how it helps?
Payment TypePayment (Now or later)By default – “LATER”It describes whether the payment will be made immediately or at a later stage. Based on the same, a Financial Voucher is made.
Any Advance?For the Advance PaymentNoIn few cases, when you make a INVOICE, you can also receive the Advance money from Customer. ERP helps you to make an Advance Voucher as part of this.
Terms And ConditionsBusiness Terms And conditionsNoIt’s the General Terms and Conditions for the Delivery etc. If you can also make templates and use it.
Ship ModeTransport modeNoThis describes us about the type of transport for delivery. It may be by Air, Cargo, etc.
eWay Bill NoeWay Bill NoNoIf you are shipping the items, then you can enter the eWay Bill no that’s generated by Indian Govt Portal.
eWay Bill DateeWay bill DateNoDate of the eWay Bill specific to Indian Govt
MemoAdditional informationNoYou can add more Information about the Sales Order.  
Payment termsPayment termsNoThese give us the details about payment terms between the two Parties that they have agreed on. You can define multiple “Payment Terms” in Master and use them.
Payment Terms DescriptionPayment TermsNoThis is description of Payment terms.
Sub TotalTotal priceYesSubtotal of the Order.
GROSS / Cash DiscountDiscount on the total PaymentNoIt’s the Overall discount on the Order. Two types Cash Discount – You can give the Discount in “Amount” only.Trade Discount  – You can give either in “%age“ or in “AMOUNT”
Total before taxAmount before taxYesIt’s the Total amount without Tax amount
Total taxTax amountYesIt’s the total Tax on the line items.
Round offRounded off amountNoEnter the Amount, if you want to change it. Its small amount that can be added or removed from the TOTAL AMOUNT to round-off.
  TotalTotal Amount of the Order  YesThis is the total Order amount after rounding off.

Additional Fields based on the “Sales Settings” on what additional charges to be booked.

Field IDField NameMandatory?Field Description and how it helps?
Postage ChargesPostage Amount, if anyNoEnter the Amount, if you need it. (Other charges for Order). Enter the Postage charges that will be billed to the Buyer, if any.
Postage SAC CODESAC CodeNoEnter the SAC Code, if you need it.
Postage TaxPostage TaxNoSelect the Taxes, if you need it. This gives the tax levied for postage.it comes under different GST slabs for the type of product.
Packing ChargesPacking Charges, if anyNoEnter the Amount, if you need it. (Other charges for Order). This is the Charges for the product that’s billed to the buyer, if any
Packing SAC CODESAC CODENoEnter the SAC Code, if you need it.
Packing TaxTax for the ChargesNoSelect the Taxes, if you need it. This gives the total TAX on transport cost of the product.
Shipping ChargesShipping Charges, if anyNoEnter the Amount, if you need it. (Other charges for Order). This is the Shipping Charges for the product that’s billed to the buyer, if any
Shipping SAC CODEShipping SAC CODENoEnter the SAC Code, if you need it.
Shipping TaxTax for the ChargesNoSelect the Taxes, if you need it. This gives the total TAX on transport cost of the product.
Insurance ChargesInsurance Amount, if anyNoEnter the Amount, if you need it. (Other charges for Order) Enter the Insurance amount for the product to be delivered, if any
Insurance SAC CODEInsurance SAC CODENoEnter the SAC Code, if you need it.
Insurance TaxTax for the ChargesNoSelect the Taxes, if you need it. This gives the total TAX on the freight insurance amount.

If you set Consignee = “YES”, then the below screen OPENS and the details are explained below for Direct Invoice Inventory screen.

Field IDField NameMandatory?Field Description and how it helps?
ConsigneeConsigneeBy Default = NOThis is the Recipient of the Goods that are shipped. It tells whether we have a Consignee or not?
Consignee IdConsignee IDYesThis is mandatory, if you enable “Consignee = Yes” This is the identification number given to a consignee.
Consignee NameName of the ConsigneeYesConsignee Name / Business Name.
Consignee StateConsignee StateYesConsignee State and its important for Indian GST purpose.
Consignee Shipping AddressShipping address of ConsigneeYesAddress of the shipment receiver (Consignee).
Calculate Tax based on ConsigneeTax on ConsigneeBy Default = NOThis tells whether to apply the tax on the Consignee or not.

Enter Vehicle Details

Most of these data are entered for recording purpose. Few important parameters.

Field IDField NameMandatory?Field Description and how it helps?
Vehicle / Courier detailsVehicle /courier detailsNoEnter Vehicle / Courier details like Transporter Name / Courier name, vehicle number, etc.
Gate pass IdGate Pass Voucher IDNoThis is the GATE Pass no that’s created in GATEPASS Module in ACTouch ERP. This helps to connect the GATE PASS Entry to the Invoice / GRN data.
Gate pass DateGate Pass DateNoDate of Gate Pass entry in ERP
Transporter NameTransporter NameNoTransporter Name / person Name
Transporter GSTNTransporter Tax IDNoTAX NO. It’s a unique ID necessary for businesses.
Vehicle No.Transporter Vehicle NumberNoEnter Transporter Vehicle Number.
Courier NameCourier Agency NameNoCourier Agency Name responsible for delivering the product to the customer or businesses.
Courier BranchCourier Branch NameNoCourier Agencies Branch
Courier DateDate of product dispatchNoDispatch Date.
Docket NumberDoc NoNoDocket Number
GC / LR Date / Ship Bill DateReceipt of the lorry  NoIt is the Date of Receipt LR No etc that’s received from the transporter.
GC / LR Number / Ship Bill NumberLorry receipt numberNoThis gives the lorry receipt from the transporting company.
Packing DateDate of packageNoDate the product was packaged.
Packing NumberPackage numberNoPackage no for reference.
Number of PackagesTotal number of packageNoTotal number of packages that’s delivered
Weight of PackagesTotal weight of the packagesNoTotal weight of the packages.

Direct Invoice Inventory – Line level Product details Upload Feature.

As part of Create an Invoice, we also give an option to upload the product details at one go. We have customer, who use the same to upload around 500+ line items as part of Invoice Creation. This saves around 2 Hours to create an invoice with 500 lines at one go.

Few customers, who manage the Sales Orders with 100s of line items, it takes time to enter the data one by one.  In few cases, it may be easy to create these data in Excel and upload them into ERP.

We built an interface for the Data upload that’s similar to an excel screen interface.

  1. You create the product line details with necessary fields.
  2. Paste the data on the Excel Interface
  3. Click on “Validate” and this process will ensure the Accuracy of Data.
  4. If you find any errors, then fix them.
  5. Once the data is OK, press “save”.
  6. Now application will start loading the records on the INVOICE LINE Level.

Notes: Don’t upload more than 40 records at a time. This takes around 1 to 2 min to load the data on the screen. So you can upload the data in multiple tranches

Was this article helpful to you? Yes No