`FREE CODE - IMPORT PURCHASE WITH BATCH,WITH INVENTORY

sanskruti · Dec 1, 2016

sanskruti.gld@gmail.com
can u sendme excel file sir

Rajsrisrimal · Jan 3, 2017

sir please mail me
rajsrisrimal@gmail.com

ketan9012 · Feb 6, 2017

sir please mail me excel file
ketan9012@gmail.com

HAROON2015 · Mar 15, 2017

Haroon358@gmail.com
sir please send the excel file

thank you in advance

Mukesh Bansal · Mar 24, 2017

Sir, Plz send Excel file to this email id
mkhisar@gmail.com

Sambhaji S Khedkar · May 7, 2017

sambhajiskhedkar@gmail.com

VRS · Aug 16, 2017

Dear Sir,
Send The Exce File to my mail id -- vrs1919@gmail.com

rajendra mithari said: ↑

DEAR ALL, AFTER MANY PRACTICE I DONE IMPORT PURCHASE WITH STOCK ITEM WITH BATCH ALLOCATION AND IN INVOICE MODE.

JUST CHANGE $$FileReadCell:##Counter:1
##COUNTER:1 MEANS FIRST COLUMN WHATEVER ROW NUMBER

ITS SUCCESS , JUST TELL ME WHY STOCK IMPACT IS NEGETIVE SAVED ?
WHAT IS LOGIC OF ISDEEMEDPOSITIVE ?

PL SLOVE MY QUERY.

;
;;---------------- PURCHASE IMPORT-------------------

[Report: purchaseimport]

[Form: purchaseimport]

Part : purchaseimport
Back ground : @@SV_RELEASEDBLUE
On : Form Accept : Yes : Form Accept
On : Form Accept : Yes : Call : purchaseimportfunc

[Part: purchaseimport]

Line : purchaseimportln1, purchaseimportln2 ;, cashgl

[Line: purchaseimportln1]

Field : Long Prompt,purchaseimportfld1
Local : Field : Long Prompt : Set As : "Enter File Name (eg:\File1.xlsx) :"

[Line: purchaseimportln2]
Field:long prompt,purchaseimportfld2
Local:Field:long prompt:Set as:"Select Voucher type Name (Purchase)"

[Field: purchaseimportfld1]
Use : Name Field
Modifies : purchaseimportvar1
Full width : Yes
Max : 100
[Fieldurchaseimportfld2]
Use:name field
Table : ExtractVoucher Type
Show Table : On Blank
Modifiesurchaseimportvar2
Full Width:Yes
max: 100
[Variable: purchaseimportvar1]
Type : String
[Variableurchaseimportvar2]
Type:String
[system : Variable]
purchaseimportvar1 :""
purchaseimportvar2:""

;;-----------------------------------------------

[Function: purchaseimportfunc]
Variable : Counter : Number : 2

1000 : OPEN FILE : ##purchaseimportvar1 : Excel : Read
1010 : WHILE : NOT $$IsEmpty$$FileReadCell:##Counter:1)
1011: Set file Log On
1012: Log:$vouchernumber

40 : NEW OBJECT : Voucher
30 : SET : SVViewName : $$SysName:InvVchView
60 : SET VALUE : VoucherTypeName : ##purchaseimportvar2
50 : SET VALUE : Date : $$Date($$StringPart$$FileReadCell:##Counter:4):0:2 +"/"+ $$StringPart$$FileReadCell:##Counter:4):2:2 + "/"+$$StringPart$$FileReadCell:##Counter:4):4:4))
90 : SET VALUE : VoucherNumber :$$FileReadCell:##Counter:13 + "/"
100 : SET VALUE : PartyLedgerName : $$String@partynm
101 : SET VALUE : PartyName : $$String@partynm
110 : SET VALUE : IsInvoice : Yes
111 : Set Value: amount:$$AsAmount:$$FileReadCell:##Counter:7
112 : Set Value: REFERENCE :$$FileReadCell:##Counter:5
113 : Set Value: ReferenceDate:$$Date:$$FileReadCell:##Counter:4
114 : Set Value: CSTFORMISSUETYPE:"c form"

130 : INSERT COLLECTION OBJECT : LEDGERENTRIES
140 : SET VALUE : LedgerName : $$String@partynm
150 : SET VALUE : IsDeemedPositive : No
151 : SET VALUE : IsPartyLedger : Yes
160 : SET VALUE : Amount : $$AsAmount:$$FileReadCell:##Counter:7
170 : SET TARGET : ..

130a : INSERT COLLECTION OBJECT : LEDGERENTRIES
140a : SET VALUE : LedgerName : $$String@purgl
170a : SET TARGET : ..

180 : INSERT COLLECTION OBJECT : INVENTORYENTRIES
190 : SET VALUE : StockItemName : $$FileReadCell:##Counter:24
210 : SET VALUE : ActualQty : ($$TgtObject$$AsQty:"-1"))
220 : SET VALUE : BilledQty : ($$TgtObject$$AsQty:"-1"))
230 : SET VALUE : Rate : ($$TgtObject$$AsRate:$$FileReadCell:##Counter:7))
240 : SET VALUE : Amount : $$AsAmount:$$FileReadCell:##Counter:7

250 : INSERT COLLECTION OBJECT : BATCHALLOCATIONS
260 : SET VALUE : GodownName : "stockyard"
270 : SET VALUE : BatchName : $$FileReadCell:##Counter:11
280 : SET VALUE : ActualQty : ($$TgtObject$$AsQty:"-1"))
290 : SET VALUE : BilledQty $$TgtObject$$AsQty:"-1"))
300 : SET VALUE : Rate : ($$TgtObject$$AsRate:$$FileReadCell:##Counter:7))
310 : SET VALUE : Amount : $$FileReadCell:##Counter:7
320 : SET TARGET : ..

330 : INSERT COLLECTION OBJECT : ACCOUNTING ALLOCATIONS
340 : SET VALUE : LedgerName : $$String@purgl
360 : SET VALUE : Amount : $$AsAmount:$$FileReadCell:##Counter:7
361 : Set Value: IsDeemedPositive : Yes
370 : SET TARGET : ..

1255 : Set Value : Narration:$$FileReadCell:##Counter:12
;1255A : Set Value:ENGNOPURCHASE:$$FileReadCell:##Counter:12
1256a: SET VALUE : PersistedView : ##SVViewName
1256 : Create Target
1257 : INCREMENT : Counter
1257b: Set File Log Off
1257c: Log:$vouchernumber

1258 : END WHILE
1259 : CLOSE FILE

410 : MSGBOX : "Status" : "Created Purchase Voucher"
440 : RETURN

[System:formula]
myvchno$$FileReadCell:##Counter:2) + $$FileReadCell:##Counter:1
partynm :"Hyundai Motors India LTD "+$$FileReadCell:##Counter:8
purgl:$$FileReadCell:##Counter:8 + " purchases"
bilqty:$$AsQty:$$FileReadCell:##Counter:25
VCHNO:$$FileReadCell:##Counter:13 +"/"+ $$String$$FileReadCell:##Counter:2)
Click to expand...

santosh swami · Sep 25, 2017

Dear Sir,
Send The Exce File to my mail id - swamisantosh@gmail.com

akash7474 · Sep 28, 2017

please send the excel file to akashmjain@gmail.com

akash7474 · Nov 17, 2017

please send the excel file to akashmjain@gmail.com

Rakesh Kumar · Nov 18, 2017

please send the excel file at : pvr.rakeshsharma@gmail.com

raju kumar · Dec 12, 2017

Dear Sir,

Please Send Excel file
rajutally@hotmail.com

raju kumar · Dec 12, 2017

Dear Sir,

Please Send Excel file
rajutally@hotmail.com

balajidharani1978 · Jan 9, 2018

Can you please send the Excel file to balajidharani1978@yahoo.co.in

balajidharani1978 · Jan 9, 2018

Can you please send the Excel File to balajidharani1978@yahoo.co.in

Suneel Kumar · Jan 29, 2018

Can you please send the Excel File to suneel@hellorohtak.com

Ras Raj · Feb 6, 2018

Sir plz send excel file
rasrajras@gmail.com

sumamehtra · Mar 12, 2018

Sir plz send excel file
sumamehtra@gmail.com

RAJESH BHANUSHALI · Apr 4, 2018

Sir plz send excel file
rajeshmkhaniya@gmail.com

RAJESH BHANUSHALI · Apr 4, 2018

Sir plz send excel file
rajeshmkhaniya@gmail.com

RAJESH BHANUSHALI · Apr 4, 2018

Sir plz send excel file
rajeshmkhaniya@gmail.com

RAJESH BHANUSHALI · Apr 4, 2018

Sir plz send excel file
rajeshmkhaniya@gmail.com

SURENRA · Apr 4, 2018

hello guys
i need this type of utility.
if anyone have then send their contact details hrsurendra20@gmail.com

sumamehtra · Aug 11, 2018

sumamehtra@gmail.com

Devaki · Aug 13, 2018

devakimuthusundar@gmail.com

Log in or Sign up

`FREE CODE - IMPORT PURCHASE WITH BATCH,WITH INVENTORY

sanskruti Member

Rajsrisrimal Member

ketan9012 New Member

HAROON2015 Member

Mukesh Bansal New Member

Sambhaji S Khedkar New Member

VRS Member

santosh swami New Member

akash7474 New Member

akash7474 New Member

Rakesh Kumar Member

raju kumar New Member

raju kumar New Member

balajidharani1978 New Member

balajidharani1978 New Member

Suneel Kumar New Member

Ras Raj Member

sumamehtra Member

RAJESH BHANUSHALI Member

RAJESH BHANUSHALI Member

RAJESH BHANUSHALI Member

RAJESH BHANUSHALI Member

SURENRA New Member

sumamehtra Member

Devaki Member

Share This Page

Log in or Sign up

`FREE CODE - IMPORT PURCHASE WITH BATCH,WITH INVENTORY

sanskruti Member

Rajsrisrimal Member

ketan9012 New Member

HAROON2015 Member

Mukesh Bansal New Member

Sambhaji S Khedkar New Member

VRS Member

santosh swami New Member

akash7474 New Member

akash7474 New Member

Rakesh Kumar Member

raju kumar New Member

raju kumar New Member

balajidharani1978 New Member

balajidharani1978 New Member

Suneel Kumar New Member

Ras Raj Member

sumamehtra Member

RAJESH BHANUSHALI Member

RAJESH BHANUSHALI Member

RAJESH BHANUSHALI Member

RAJESH BHANUSHALI Member

SURENRA New Member

sumamehtra Member

Devaki Member

Share This Page

Useful Searches