1.Prepare inventory report for Restaurant department – SFS R, HYW R, TAC R (daily). We have master file report and pull-out report from NetSuite then use VLOOKUP function to do the report by manual.
Input Daily – LA office can look up in the movement and prepare transferred
2.Prepare inventory movement report for all departments as the end of month (monthly). We have master file report and pull-out report from NetSuite then use VLOOKUP function to do the report by manual.
Semi-monthly – all locations
3.Update information (Supplier invoice number and ETA date) for direct shipment (Shipper is supplier) except TLF, TLA and MFI in PO in NetSuite.
Weekly – update in NetSuite
4.Review pending PO (over than 1 month) and follow up status with supplier then update information including reason for delay.
By Direct shipment and by consolidation
5.Help coordinate and follow up status of sourcing item and development product and others that produce by our own factory (TLF, TLA and MFI) and update information in sourcing list file.
6.Process purchasing for both Oversea and Thai when receive purchase requisition from Sunlee USA. Prepare price comparison by Request, compare and summarized FOB price then update to Sunlee USA to make final decision.