When you want to change the location from the existing inventory location. You must know the existing spot of the drum before changing it to the new location. Below is the easiest way to change the locations from the software: LABEL ON A DRUM, A CAN, OR ON A BOTTLE This process can be performed […]
Category: Franscent
SCANNING STOCK
The software gives you an alert to scan the remaining stock where you put RFID on drums. All the drums are located in the production department. Slightly open the discrepancy reports, then you have all the reports on your screen. Open up the dialog box (not scan last 3 days), and you will be able […]
How to dispatch order
Here you will know how to dispatch a consumer order. This process occurred in the production department. You perform this process after you had done all the previous procedures, before you step in firstly you have the ID and the password to log in or to access the site. And you must note the dispensed […]
Dispense Procedure for order
In this course of action, you grasp how to blend two or more chemicals or a single chemical for a consumer. You need to log in before. This method performs in the production department. You must have the consumer name, a weight machine that is plugged into your PC or a laptop, a scanner that […]
Record Shaking
In this procedure, we will learn how to manufacture raw materials of chemicals in a liquid state. This cycle is manufactured in the production house. You must require a shaking machine, a scanner that scans the QR code label, and a website login. A shaking machine can shake the drums or the cans in just […]
FST Transfer Order And Dispatch
Shop Order Request when out of stock: azkar
DRUM Profit
SELECT O.documenttextID, OP.final_price,OP.products_quantity,OP.lineAmount,OP.tktMisc [Loose Qty],op.tktSPPercentage [Loose Rate], FSTPO.Sremarks,[RR].locationDetail [DIS DRUM],RR.ordersid,[FSTPO].fileNo,RRPO.locationDetail [PODRUM],DHPO.qty as [PODHqty],P.products_model,FSTO.sRemarks AS DISPATCHBATCHNO,O.date_purchased, DA [REF FST],FSTO.doctypeId,FSTO.filenO,OP.products_id FROM ORDERS [O]LEFT JOIN orders_products [OP] ON O.orders_id = OP.orders_idLEFT JOIN CL_METRO_FST.DBO.ORDERS AS [FSTO] ON FSTO.orders_id = ISNULL(DA,0)LEFT JOIN CL_METRO_FST.DBO.DISPENSEHISTORY [DH] ON DH.batchNo = FSTO.sRemarksLEFT JOIN CL_METRO_FST.DBO.REgisterRFID [RR] ON RR.RFID = DH.RFIDLEFT JOIN CL_METRO_FST.DBO.ORDERS AS [FSTPO] ON […]