Showing posts with label Trading. Show all posts
Showing posts with label Trading. Show all posts

Saturday, April 13, 2019

COMBINED SMS TEXT & CLOUD ERP A MUST NEED FOR THE FRANCHISE AND CONSIGNMENT OPERATIONS

To: Business Owners, Entrepreneurs, Board Chairs, Presidents, CEOs, Vice Presidents, General Managers, Managers, Officers and Supervisors

Good news! All you need is a text from the ordinary mobile/cell phone of a simple worker to automatically facilitate text transfomation into reports in Cloud ERP and get real time updates on your business without asking anyone. This latest technology combining SMS TEXT and CLOUD ERP can be achieved on a very economical way.




This is very useful where the business has multiple store outlets, warehouses or offices having difficulties of gathering transactions to record in the company's computerized system in REAL TIME. A must need technology fit for the franchise, consignment, remote site projects, trading, retail, distribution and supply chain operations.



This new technology is being used now by
Don Benito's Filipino Delicacies
Main Office: 929 Ibarra St, Sampaloc, City of Mahila, NCR, Philippines
W: http://www.donbenitos.ph/#home
F: https://www.facebook.com/donbenitoscassava/?epa=SEARCH_BOX
Branches/ Commissaries = 15
Store Outlets = 350+ Located all over the Philippines
Employees = 650+
Company plans are to add more branches, outlets and to export due to soaring franchising demand


Reasons why to send text instead of other means to record transaction activities in a computerized system are as follows:
  1. No computerized system in the location
  2. There is no internet in the location
  3. No computer to use
  4. No budget to buy computer
  5. Employee is not adept on how to use computer
  6. Frequent power interruptions
  7. Employee has only knowhow in using simple mobile/cell phone
  8. Texting is the fastest and easiest way to send the transactions
  9. To avoid huge labor expenses just to record the business transactions
  10. To get the why, what and how of the business in REAL TIME
  11. To make timely decision in order to prevent losses, make new plans and execute
  12. To MONITOR and MANAGE efficiently the business

SMS Text solves your inaccurate information and delays problems in recording transactions such as the activities of
  1. procurement, 
  2. stock receipt with storage
  3. stock issues to production and expenses 
  4. production, 
  5. stock transfer, 
  6. sales with packaging assembly, discounts (PWD, SC) and tax on sales
  7. stock returns
  8. stock spoilage
  9. stock issues for beggars, free taste,  representation and promotion
  10. receivables, 
  11. payables, 
  12. expenses, 
  13. collections, 
  14. payments, 
  15. bank deposits, and
  16. advances for personal, advance for liquidation and auto salary deduction,
Note: other customised activities can be added





Add caption


The above texts trigger the computerized system to do the following:
  1. automatic receipt of text in the text receiver program
  2. automatic dayend to transfer text messages to transaction program
  3. automatic completion of information in the transaction program
  4. automatic generation of accounting entries
  5. automatic posting of transaction per program
  6. automatic integration of posted transaction to general ledger history
  7. automatic scheduling of preparation of reports such as for operation and financial
  8. automatic scheduling of sending reports to designated user/s

The above activities using SMS TEXT and CLOUD TECHNOLOGIES are only possible by using the very affordable Ikonomikal Cloud ERP available on a monthly subscription. Meaning no financial impact. It is a utility expense and therefore not capitalised.
Software link: https://ikonomikal.com

Click this link to get more explanation on how it is done and what text format to use.
Related blog:
CONSIGNMENT IN CLOUD & SMS TECHNOLOGIES
Blogs 



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

Saturday, March 16, 2019

HOW TEXTS FROM SIMPLE MOBILE PHONE AUTOMATICALLY UPDATE THE OPERATION AND FINANCIAL REPORTS OF IKONOMIKAL CLOUD ERP

Mobile phone is a communication gadget that is very important to every person due to its usefulness and being handy. Its feature of sending and receiving messages is recently enhanced. It now sends simple and short business transaction texts to Ikonomikal Cloud ERP business software to automatically record, post and provide real time operation and financial reports. The advantage of text over the cloud is the former works, without internet and user's knowledge of computer, where data from remote areas are obtained.

The combination of SMS/ Text and Cloud technologies in Ikonomikal Cloud ERP overcomes the difficulty of gathering data in real time from remote areas without suffering from intermittent internet service to no internet at all but with continuous mobile phone communication. This innovation helps enterprises with multiple and remote offices/ branches/ companies/ locations having staffs using only simple mobile phone. An advantage to the owners who reside in the suburban city while their businesses are in the far-flung areas where mobile phone is the only fastest means of communication.




EXAMPLE:
TEXT FOR NORMAL SALES WITH DISCOUNT AND NOTES:



            SALES INSERT
          #r01 INSERT
          #itemCode IC00001
          #invQty 1
          #uomCode BOX
          #discType SNR
          #discAmt 100
          #notes sr.# 12345689


-----------------------------
Note: Types of “discType”:
REG - Regular
ESP - Especial
PWD – Persons With Disabilities
STD - Student Discount
SNR – Senior Discount
     

How it works





Ikonomikal Texts Receiver Programs
Ikonomikal Cloud ERP without human control triggers the below programs.

Text Receiver Program automatically
1. Receives texts through SMS Gateway
2. Day Ends the received texts and transfer them to Transaction programs

Transaction Programs automatically
3. Completes the information
4, Generates accounting entries
5. Posts the transactions
6. Sends posted transactions to General Ledger History
7. Updates the corresponding Subsidiary Ledgers
The best feature is Ikonomikal automatically closes accounting entries to close to Income and Expense then to Retained Earnings. This means Ikonomikal provides instant complete Financial Reports any time and not to wait for month end and year end closing.

Scheduler Program automatically
8. Prepares reports on schedule, and
9. Sends reports on schedule as well to user inbox or through text to the mobile phone.

The good point is there is no human intervention in Ikonomikal Cloud ERP base on the above facts should anyone shall observe.

Text Receiver Programs  of Ikonomikal Cloud ERP are group in the below Modules. These are only the start and definitely the clients will be requesting for more.





Inventory Control and Assembly
1. IC Text Stock-To-Stock Transfer
2. IC Text Receipts
3. IC Text Receipt Returns
4. IC Text Shipments
5. IC Text Shipment Returns
6. IC Text Receipts (Price List)
7. IC Text Receipts Returns (Price List)
8. IC Text Damages
9. IC Text Damages Returns
10. IC Adj To Std/User U/C Batch Run
11. IC Rollup Adj To Std/User U/C Batch Run


Sales Order
SO Text Invoice w/ Receipt
Note: With automatic assembly cost accounting of the packaging materials and labor of the sold finished goods of the food chain industry.

Purchase Order
PO Text Invoice w/Receipt

Treasury
TR Text Miscellaneous Cash Payment


How to go to Text Receiver programs of Inventory Control and Assembly Modules of Ikonomikal Cloud ERP


Click Program>Main>Core Business>Inventory Control and Assembly>Options and Helpers

Bigger image

Click Favorites to show Shortcuts. This is only possible if the program was previously selected to show in the shortcuts for quick access.

  


IC Text Stock-To-Stock Transfer

Text Transferring Inventory From Commissary to Driver
People Involved: Commissary Personnel to Driver #1


Steps
1.  Select the number of
      Your Company Ikonomikal SMS Gateway
      +63 9XX XXXX (example only)
      While your number must be registered in Ikonomikal as a User
2. Open the “Messages” App (or an equivalent) from your mobile phone.
3. Create a new Text Message and enter the gateway number on the recipient box (or equivalent)
4. Enter the message:

Format:
STOCKTRANSFER INSERT
#docDte <THE DATE OF TRANSACTION IN YYYYMMDD FORMAT>
#r01 INSERT
#itemCode < THE ITEM CODE >
#toWH <THE WAREHOUSE ID TO TRANSFER TO (USUALLY THE DRIVER WAREHOUSE)>
#invQty <QUANTITY TO TRANSFER, MUST BE A NUMBER>
#uomCode <THE UNIT OF MEASURE. Ex. KG,PIECE, GRAMS, ETC>

docDte is ….the date of transaction (will use the current date when removed or left blank/zero(0)).
itemCode is ….the item code.
toWH is ….the warehouse code to transfer to. In ikonomikal, drivers are also warehouses.
invQty is ….the quantity to transfer.
uomCode is ….the unit of measure (ex. KG, PIECE, BOX).


Text Example of Stock-To-Stock Transfer:

STOCKTRANSFER INSERT
#docDte 20181217
#r01 INSERT
#itemCode IC0003U
#toWH 0400D1
#invQty 5.5
#uomCode TRAY
#r01 INSERT
#itemCode IC0009U
#toWH 0400D1
#invQty 370
#uomCode TRAY
#r01 INSERT
#itemCode IC0001U
#toWH 0400D1
#invQty 94
#uomCode TRAY
#r01 INSERT
#itemCode IC0020
#toWH 0400D1
#invQty 3,007
#uomCode PC


Note:
4 items were entered the’ IC0009U, IC0003U, IC0001U and IC0020 to transfer from commissary stocks to the driver (ex. 0400D1 is Driver 1 warehous) who will deliver to the outlets. The “#r01 INSERT” indicates a new set of items to be transferred. Only items with quantities are allowed.

5. Press send and wait for the confirmation.
    The confirmation should almost resemble the following message:
a.       The INSERT operation for STOCKTRANSFER was received and for validation!
b.       The INSERT operation for STOCKTRANSFER was queued for processing under transaction id xxxx!
c.       The INSERT operation for STOCKTRANSFER under transaction id xxxx was successful!


The Text Receiver Program

Text Receiver Program of Ikonomikal


Printed Report of Received Text
Text received in Ikonomikal 

The automatic Day End on the Text Receiver Program automatically transfers the text and completes the information in the appropriate program such as below. This program also automatically posts the transaction.







Printed Report of the transaction




Text Receiving Inventory From Driver To Outlet
People Involved: Store Outlet Personnel and Driver

Steps
1. Select the number of
      Your Company Ikonomikal SMS Gateway
      +63 9XX XXXX (example only)
      While your number must be registered in Ikonomikal as a User
2. Open the “Messages” App (or an equivalent) from your mobile phone.
3. Create a new Text Message and enter the gateway number on the recipient box (or equivalent)
4. Enter the message:

Format:
STOCKTRANSFER INSERT
#docDte <THE DATE OF TRANSACTION IN YYYYMMDD FORMAT>
#r01 INSERT
#itemCode < THE ITEM CODE >
#toWH <THE WAREHOUSE ID TO TRANSFER TO (USUALLY THE OUTLET WAREHOUSE)>
#invQty <QUANTITY TO TRANSFER, MUST BE A NUMBER>
#uomCode <THE UNIT OF MEASURE. Ex. KG,PIECE, GRAMS, ETC>

docDte is ….the date of transaction (will use the current date when removed or left blank/zero(0)).
itemCode is ….the item code.
toWH is ….the warehouse code to transfer to. In ikonomikal outlets are also warehouses.
invQty is ….the quantity to transfer.
uomCode is ….the unit of measure (ex. KG, PIECE, BOX).


Text Example of Stock-To-Stock Transfer:

STOCKTRANSFER INSERT
#docDte 20181217
#r01 INSERT
#itemCode IC0003U
#fromWH 0400D1
#toWH 0401
#invQty 5.5
#uomCode TRAY
#r01 INSERT
#itemCode IC0009U
#fromWH 0400D1
#toWH 0401
#invQty 370
#uomCode TRAY
#r01 INSERT
#itemCode IC0001U
#fromWH 0400D1
#toWH 0401
#invQty 94
#uomCode TRAY
#r01 INSERT
#itemCode IC0020
#fromWH 0400D1
#toWH 0401
#invQty 3,007
#uomCode PC


5. Press send and wait for the confirmation.
   The confirmation should almost resemble the following message:
a.       The INSERT operation for STOCKTRANSFER was received and for validation!
b.       The INSERT operation for STOCKTRANSFER was queued for processing under transaction id xxxx!
c.       The INSERT operation for STOCKTRANSFER under transaction id xxxx was successful!


IC Text Receipts

Receiving Inventory To Increase Commissary Stocks
People Involved: Commissary Personnel

Format:
STOCKRECEIPT INSERT
#docDte <THE DATE OF TRANSACTION IN YYYYMMDD FORMAT>
#r01 INSERT
#itemCode < THE ITEM CODE >
#rcpQty <QUANTITY TO RECEIVE, MUST BE A NUMBER>
#uomCode <THE UNIT OF MEASURE. Ex. KG,PIECE, GRAMS, ETC>

IC Text Text Receipt Example:

STOCKRECEIPT INSERT
#docDte 20181107
#r01 INSERT
#itemCode IC0001U
#rcpQty 50
#uomCode TRAY


IC Text Damages

Spoilage Inventory


Format:
SPOILAGE INSERT
#docDte <THE DATE OF TRANSACTION IN YYYYMMDD FORMAT>
#r01 INSERT
#itemCode < THE ITEM CODE >
#dmgQty <SPOILAGE QUANTITY, MUST BE A NUMBER>
#uomCode <THE UNIT OF MEASURE. Ex. KG,PIECE, GRAMS, ETC>



IC Text Damages Example:

SPOILAGE INSERT
#docDte 20181021
#r01 INSERT
#itemCode IC0001
#dmgQty 100
#uomCode BOX


SO Text Invoice w/ Receipt


Recording Of Sales
People Involved: Outlet personnel
        
Format:
SALES INSERT
#docDte <THE DATE OF TRANSACTION IN YYYYMMDD FORMAT>
#r01 INSERT
#itemCode < THE ITEM CODE >
#invQty <QUANTITY TO RECORD AS SALES, MUST BE A NUMBER>
#uomCode <THE UNIT OF MEASURE. Ex. KG,PIECE, GRAMS, ETC>

docDte is ….the date of transaction (will use the current date when removed or left blank/zero(0)).
itemCode is …. the item code.
invQty is ….the quantity to record as sales.
uomCode is ….the unit of measure (ex. KG, PIECE, BX).


SO Text Invoice w/ Receipt Example:

SALES INSERT
#docDte 20181021
#r01 INSERT
#itemCode IC0001
#invQty 50
#uomCode BX



Other Formats of Recording Of Sales

Format:
SALES INSERT
#r01 INSERT
#itemCode < THE ITEM CODE >
#invQty <QUANTITY TO RECORD AS SALES, MUST BE A NUMBER>
#uomCode <UNIT OF MEASURE>
#discType <TYPE OF DISCOUNT, ex. REG, ESP,PWD, and STD>
#discAmt <DISCOUNT AMOUNT, MUST BE A NUMBER>
#notes <ANY NOTES REFERENCE, OPTIONAL>
#saleType <SALE TYPE EITHER IT’S A SALE, FREETASTE OR REPRESENTATION>

Types of “discType”:
·       REG - regular
·       ESP - Especial
·       PWD – Persons With Disabilities
·       STD – Student Discount
·       SNR – Senior Discount

Take note that you don’t have to include the #discType, #discAmt, and #notes because they are all optional. But if you have to, this is how it would look like:

FOR NORMAL SALES WITH DISCOUNT AND NOTES:
SALES INSERT
#r01 INSERT
#itemCode IC00001
#invQty 1
#uomCode BOX
#discType SNR
#discAmt 100
#notes sr.# 12345689

FOR NORMAL SALES WITH NOTES ONLY:
SALES INSERT
#r01 INSERT
#itemCode IC00001
#invQty 1
#uomCode BOX
#notes received 28.2.2019


FOR FREETASTE WITH DISCOUNT AND NOTES:
SALES INSERT
#r01 INSERT
#itemCode IC00001
#invQty 1
#uomCode BOX
#discType SNR
#discAmt 100
#notes sr.# 12345689
#saleType C007

FOR REPRESENTATION WITH DISCOUNT AND NOTES:
SALES INSERT
#r01 INSERT
#itemCode IC00001
#invQty 1
#uomCode BOX
#discType SNR
#discAmt 100
#notes sr.# 12345689
#saleType C008



Recording Of Expenses

Format:
EXPENSES INSERT
#r01 INSERT
#itemCode < THE ITEM CODE >
#invQty <QUANTITY TO RECORD AS SALES, MUST BE A NUMBER>
#uPrc  <UNIT COST TO RECEIVE, MUST BE A NUMBER>
#uomCode <UNIT OF MEASURE>
#discType <TYPE OF DISCOUNT, ex. REG, ESP,PWD, and STD>
#discAmt <DISCOUNT AMOUNT, MUST BE A NUMBER>
#notes <ANY NOTES REFERENCE, OPTIONAL>
Types of “discType”:
·       REG - regular
·       ESP - Especial
·       PWD – Persons With Disabilities
·       STD – Student Discount
·       SNR – Senior Discount

Take note that you don’t have to include the #discType, #discAmt, and #notes because they are all optional. But if you have to, this is how it would look like:

FOR NORMAL EXPENSES WITH DISCOUNT AND NOTES:
EXPENSES INSERT
#r01 INSERT
#itemCode IC00001
#invQty 1
#uPrc 28.8
#uomCode BOX
#discType SNR
#discAmt 100
#notes sr.# 12345689

FOR NORMAL EXPENSES WITH NOTES ONLY:
EXPENSES INSERT
#r01 INSERT
#itemCode IC00001
#invQty 1
#uPrc 28.8
#uomCode BOX
#notes sr.# 12345689


Recording Of Expenses (w/ Advances)

SMS/Text Format from Ordinary Simple Mobile Phone:
EXPENSES INSERT
#r01 INSERT
#itemCode < THE ITEM CODE >
#invQty <QUANTITY TO RECORD AS SALES, MUST BE A NUMBER>
#uPrc  <UNIT COST TO RECEIVE, MUST BE A NUMBER>
#uomCode <UNIT OF MEASURE>
#discType <TYPE OF DISCOUNT, ex. REG, ESP,PWD, and STD>
#discAmt <DISCOUNT AMOUNT, MUST BE A NUMBER>
#notes <ANY NOTES REFERENCE, OPTIONAL>
#advType <TYPE OF ADVANCES, ex. PER and BUS>
#empCode <EMPLOYEE CODE, ex. E001 (full list can be found at HR Employe Profile “Employee ID”)>

Types of “advTyp”:
·       PER - PERSONAL
·       BUS - BUSINESS

The itemCode for Advances is XA1220 and the uomCode is EA. Take note that you don’t have to include the #advType, and #empCode because they are all optional. But if you have to, this is how it would look like:

FOR NORMAL EXPENSES WITH ADVANCES:


FOR NORMAL EXPENSES WITH ADVANCES:
EXPENSES INSERT
#r01 INSERT
#itemCode XA1220
#invQty 1
#uPrc 300
#uomCode EA
#advType PER
#empCode E001



Related blog:
CONSIGNMENT IN CLOUD & SMS TECHNOLOGIES




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

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


Please click also the following to know more about Ikonomikal

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