Friday, May 15, 2020

HOW TO RECEIVE NO VALUE ITEM/S IN WAREHOUSE IC RECEIPTS PROGRAM


There are many ways to receive or enter warehouse item in the IC RECEIPTS Program of the Inventory Control And Assembly modules, the Warehouse Management System, of Ikonomikal Cloud ERP. The ways are:

a)    Create a batch entry and fill with data
b)    Import entry or entries from Excel file format (this is automatically generated from uploading process)
c)    Text from a simple mobile phone (this is also automatically generated from a received text)
d)    Transfer from another 3rd Party software using iKonomikal Application Programming Interface or API (this is likewise automatically generated)
e)    Uploading from CSV file format is also possible upon request (also automatically generated)

The knowledge to gain is as follows:
1)    Put Program in the Shortcuts List
2)    Quick Access to the Program
3)    Create Batch and Entry
4)    Receive No Value Items
5)    Upload in hundreds of lines the Items and its Lot and Storage using DataGrid
6)    Save, Post and Print IC Receipts Document/Entry
7)    Print Analysis Reports such as
a)    IC Item Balances
b)    IC Item Balances with Lot and Storage
c)    IC Stock Ledger Card
d)    IC Stock History

The IC RECEIPTS program has 4 windows or tabs to fill as follows:
1)    General
2)    Line Items
3)    Lot And Storage
4)    Additional GL Entries
5)    Currency





No accounting entries will be generated as the items to enter have no values. The items are from the company’s customer. The purpose is only to store the items inside the warehouse of the company. Their customer will request to stock, transfer and deliver. The revenues derived by the company are the storage and handling fees.

The create manual entry is the process to explain here on a step by step. While the rest are on their respective separate blogs.

The images below are the ways to go to the IC RECEIPTS of iKonomikal Cloud ERP.

A click of IC Receipts in the Favorites Modules under Shortcuts list on the right side is the fastest way to go to the desired program. 


But this needs first to put the user program in the Shortcuts list of the Favorites for the quick access. How to do it is just to click the dark star icon to make it yellow. The yellow star indicates that the program is already listed in the Shortcuts Favorites module as shown above. To remove is just click the star icon into dark color.



While the step by step procedure has to start by clicking and following the flow of the arrows from the top:
Programs>Main>Core Business>Inventory Control and Assembly>Transactions>IC Receipts


HOW TO RECEIVE ITEM/S IN IC RECEIPTS

Click the IC Receipts program from the Transactions group of the Inventory Control and Assembly Modules, the Warehouse Management System (WMS) of iKonomikal Cloud ERP.


Click the create New Batch icon.
Then put the date, write the description and select the branch or company,
Click Save and Close to show15 as the batch number and 02001 as the branch or company number

Click the icon New Document/Entry

1.General

It has the following boxes to fill:
Document Code (Automatically generated or inputted before saving)
Entry Date (Recording date)
Document Date (Source)                        Fiscal Period (YYYYMM)
Notes (Description)
For Branch – or company
Proj #  (Check or Uncheck)
Supplier (Code and name)
          Deliver From
DN Reference
Document Total
          (Src) Total                                              (Fnc) Total




2.Line Items

This is where to put the items to receive.

On top are the (Src) Total and (Fnc) Total amounts of all  items if with value, otherwise the total is zero.

The plus icon is the starting step to add. The minus icon is to remove the checked item.  The arrow up and down are for sorting arrangement. There is icon for Add Multiple Items.

The option icon is used to download the checked item details, to add through upload more items, and to update existing items.

The columns are:
Item Code (and Description)
BR (Branch or Company Code)
W/H (Warehouse Code)
Qty (Quantity)
U/C (Unit Cost)
(Src) Total (Source Currency)
(Fnc) Total (Functional Currency)
GUOM (Group Unit of Measure)
UOM (Unit of Measure)
Notes
Expense Acc’t
DP (Department)
CC (Cost Center)
OG (Object Group)




3.Lot And Storage

This is where to put the Lot and Storage details of items to receive in the Line Items tab.

On top are the present reference of the item code with check in the Line Items tab.

The plus icon is the starting step to add. The minus icon is to remove the checked item.  

The arrows single left and right shift direction refers to the item number from the Line Items. The extreme left or the first record item and right shift or the last record item direction is just beside. The item code appearing is the subject to indicate Lot and Storage details in the line below.

Next is the List icon to show. Then select information of pre recorded Add Lot with Storage and Serial Numbers should there be any.

The columns are:
Lot (or related reference such as Batch #)
Qty (Quantity)
Prod Date (Production)
Exp Date (Expiry)
Level (Height, Floor)
Area (Block, Site, Brgy)
Aisle (Alley, Street)
Rack (Storage Structure, Building)
Shelf (Bin, Box, Container, Cabinet, Pallet)
Source (Manually entered or from other sources)

The option icon is used to download the checked item details, to add through upload more items, and to update existing items. While the check icon is to select the line to remove.




4.Additional GL Entries

This is an optional extension of the GL JV Batch Entry of the General Ledger. Modules of iKonomikal Cloud ERP. The accounting entry entered here affects only the General Ledger History.  The entry DOES NOT AFFECT the Subsidiary Ledger such as Warehouse Item Code values.

The most common use of this is to reverse the accounting entry during the setup of beginning balance of the warehouse item with values. The reversal is required in order to zero the accounting entry and therefore to avoid affecting the General Ledger History balance. This is so because the item balance in amount is already a part of the set up of beginning Trial Balance in the system. Without reversal will double the amount of the inventory and the contra account in the General Ledger History, an overstatement as a result thereby unreconciled with the Subsidiary Ledger of inventory.

On top are Totals of Debit and Credit Balances

The columns are:
BB (Inter Base Branch or Company)
Account (Code and Description)
BR (Branch or Company)
DP (Department)
CC (Cost Center of Profit Center)
OG (Object Group)
          (Src) Debit (Could be Fnc or Other Foreign Currency)
          (Src) Credit (Could be Fnc or Other Foreign Currency)
          (Fnc) Debit (Country or Local Currency)
          (Fnc( Credit (Country or Local Currency)
          Line Desc (Transaction Description)



5.Currency

iKonomikal Cloud ERP is a multicurrency system. Hence, any transaction with Source currency (Src) other than Local currency or Functional currency (Fnc) is possible.

The entry fields/columns of (Src) Debit and Credit are available which are automatically translated to the Functional Currency (Fnc) Debit and Credit based on the nearest recorded date of Exchange Rate originating from the TR Currency Rates of the Treasury Modules.

It is also possible to enter a desired exchange rate for the transaction by entering on the on the currency rate boxes of same transaction.





HOW TO ADD MORE ITEMS IN THE LINE ITEMS TAB

The Grid template download and upload is faster to use than the export when it comes to adding more items in the Line Items tab.


Click check the empty box of the item to download. Then click the Option icon to download the grid template of the Line Items tab. Click Excel DG Export (DG=DataGrid)


Click to open the downloaded excel file located at the bottom left corner of the screen. 

Fill the Excel DataGrid Template then save the same excel file


Fill the Excel DataGrid Template then save the same excel file


Import the filled Excel DataGrid Import Template

Select the Filled Excel DataGrid Template

The background shows the imported/uploaded additional Items. The total number of Items increased  to 399 in just few seconds. Click X of the DataGrid Options to close.





SAVE IC Receipts

Enter the manual reference number in the empty document box if automatic number is not applicable before saving. 
Click the  Save Document/Entry icon as directed by the arrow,
 Document/Entry Reference number automatically appears after saving.

HOW TO PRINT IC RECEIPT DOCUMENT

Click the Printer icon to open the print engine. Click the Printer to display the PDF file format IC Receipt document.

PAGE 1

PAGE 52


The IC Receipt Document can also be downloaded in different electronic formats
PDF File
Text File
MS Excel File
MS Excel (Data Only)

Click to open the downloaded excel file located at the bottom left corner of the screen. 


PAGE 1

PAGE 52
HOW TO POST AN IC RECEIPT DOCUMENT

Posting in iKonomikal Cloud ERP is an act of permanently recording the transaction into the General Ledger History and the corresponding Subsidiary Ledgers. Meaning, the transaction cannot be changed anymore after posting. The only way to correct is to reverse and reenter correctly or adjust.

It is assumed before posting that the transaction is already checked as to the correctness and completeness. Special attention is given to the Fiscal Period where the transaction is to be posted. Fiscal Period is the appropriate accounting month and year to post. Likewise, the automatic accounting entry MUST be correct.

It is important to follow that after the transactions has been entered, checked and saved the document must be posted. This is to avoid deleting the entry or unwanted modifications.

Click SET icon to set to post. Heed the warning o check the correctness of the Fiscal Period before clicking the icon Yes

The status of the document after clicking the Set and Yes becomes unchangeable. This is the point where the chance of returning to its original status is still possible by clicking the UNSET below.



Click Request To Post icon at the mid right bottom side of the screen, followed by clicking the yes icon of Submit to Post Que and Post Request Acknowledged and Scheduled.



The Posting Sequence appeared an indication that the IC Receipts Document is finally posted and permanently recorded to the Subsidiary Ledgers but without value since the entered items have no value

PRINTING OF POSTED IC RECEIPTS DOCUMENT


The previously printed above IC RECEIPTS document was on a saved status only. The manner of printing is the same as in the above printed document.



The below printed IC RECEIPTS document is already on a posted status. The difference is the posting sequence reference is shown beneath the upper left side box. 



HOW TO PRINT THE INVENTORY ANALYSIS REPORTS

1.IC ITEM BALANCES

Go to the Shortcuts program of the Favorites Modules. Click IC Item Balances.


While the step by step process to go to the reports is to click the following icons:
Programs>Main>Analysis Reports>Inventory Control And Assembly
>IC Item Balances

>IC Inventory History

Put into the box or select the appropriate information from the box. Then click the Printer icon








2.IC ITEM BALANCES WITH LOT AND STORAGE


Select the IC Item Balances with Lot and Storage in the Report Box of same print engine of IC Item Balances. Put into the boxes or select the appropriate information from the boxes. Then click the Printer icon 

PAGE 1
PAGE 14
3. IC STOCK LEDGER CARD

The IC Stock Ledger Card can be printed from the IC Inventory History print Engine




FIRST PAGE

LAST PAGE
4. IC STOCK HISTORY


The IC Stock History can also be printed from the IC Inventory History print Engine.


FIRST PAGE
LAST PAGE

END OF BLOG
------------------------------------------------------------------------------------------
For inquiries contact:

Companies:
iKonomikal Cloud Services
Department of Trade and Industry Cert#: 04929944
Mayor’s Permit: BCN 1914-56
TIN: 224 089 131 VAT Registered

TR iKonomikal Consultants
Department of Trade and Industry Cert#: 04929961
Mayor’s Permit: BCN 1914-56-01
TIN: 224 089 131 VAT Registered

Address:
Ground Floor, TG Rolluqui Building
117 Burgos Street Corner Regalia Street
Brgy. Bagong Silang, Poblacion, Santa Cruz
Marinduque, 4902, Region 4B, Philippines

Links:

Phones
M: +63 918 229 5934 (Smart)
M: +63 917 813 4905 (Globe)
T:  +63 42 704 5312 (PLDT)

iKonomikal Cloud ERP
Software Website: https://ikonomikal.com
Company Website: https://hq.ikonomikal.com

------------------------------------------------------------------------------------------

Suggested modifications, customizations and developments with general industry use is FREE OF COST. 24/7 online Technical Support




++++++++++++++++++++++++++




3 comments:

  1. I always like and such a super contents of these post, Good info I gained more information about that. Thanks for such a helpful information. online payroll service tool

    ReplyDelete
  2. This was so Good Post! online accounting software software Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging

    ReplyDelete
  3. That's Is So nice o saw Your this blog This Was really SO Great information about online accounting tool

    ReplyDelete