|
China finance receiving and dispatching overseas ERP saves
According to us for many years the visit and the understanding, overseas ERP has looked
like all does not have warehouse receiving and dispatching to save the report or financial
receiving and dispatching saves reports this view, but in Chinese nearly all finance
personnel each month of ?? massive time, one report which certainly must leave is
receiving and dispatching saves the report, when we already purchase and are solid
After executed overseas ERP, because the Chinese finance personnel custom has used it
takes each month the commodity mobile statistical analysis report form, they still request
the system to have to be able to provide perfect receiving and dispatching save the
report, for this from the overseas ERP China business agent to all levels of users, all
the exploration and the development suits the Chinese finance personnel in in the original
ERP foundation uses financial receiving and dispatching saves the report form, but the
promotion and the service condition is not very ideal.
Theoretically analyzes, financial receiving and dispatching saves is one extremely simple
computation, is records one company each the at the beginning of stock quantity amount,
the same month leaves in every month goes into storage the quantity amount and the end of
the month balance quantity amount. But the overseas ERP system to every one all has the
detailed record compared to material receiving and dispatching, made the simple
accumulation is not good, certainly not such was actually simple, investigates its reason:
Namely has the algorithm the difference, the software limitation also has operates
improper question and so on question and network breakdown. But is worth happily is,
passes through more than two year of try to find out, we already found one successful
solution, at present already used and obtains the confirmation and the approval in the
multi- stature company, under on saved its aspect and so on problem analysis and solution
method by ERP finance receiving and dispatching carries on the detailed explanation.
Two, problem analysis
1. The financial personnel uses the ERP receiving and dispatching saves basically requests
* System report form itself each kind each at the beginning of the amount had to be equal
to the last month end of the month amount in every month;
* If has computation difference, specially returns goods and so on, must provide the
difference report form;
2. Original financial manual receiving and dispatching saves with ERP software finance
receiving and dispatching saves records the account way the difference
Manual receiving and dispatching saves ERP software receiving and dispatching saves
Computing mode Month migration average Immediately moves the average
Material cost Sometimes appears the negative value Cannot appear the negative value
Computation direction Along pushes calculates Pours pushes calculates
Other explain: The software cost computing mode has FIFO, LIFO, assigns, the standard, to
move evenly is equal, we only discuss in this when the use migration average algorithm the
situation.
3. develops the limitation in overseas ERP software which receiving and dispatching saves
* The SYMIX database does not record the material some history time the stock quantity and
the amount;
* SYMIX receives and dispatches the record and the foundation material close relevance;
4. immediately moves the weighted mean method in the ERP basic computation rule
* " Goes into storage and " other receives " in the purchase " when
does the motion average;
* " Sends in the work the material ", " the order form delivers goods
", " other sends out " when all by the current cost leaves the storehouse;
When * in " work rejected material ", " order form returned goods ",
does not make the motion weighted average computation, goes into storage by the current
cost;
* In " purchase returned goods " when leaves the storehouse by the current cost,
does not make the reverse motion average.
5. other influences receiving and dispatching save the report form the situation
Because receives and dispatches saves the computation the foundation is some period of
time all purchases class material receives and dispatches the record, if cannot guarantee
these data the integrity, will cause the data not to be consistent, mainly will include
following several kinds:
* Four sheds five enter question
* The material deletes
* The revision material codes
* Revision material type (manufacture / purchase)
* Revision material classification (calculation classification)
* The system clock is not correct
* The material processing diary loses or the accident deletes
Understood the algorithm rule and distinguished and knows possibly appeared the question,
we were allowed to try to find the solution to overcome software itself the limitation,
the automatic consummation and the processing contingency, guaranteed reported complete
and is consistent, the plan saw ??.
Three, solution
1. Programming principle
Principle summary: Completely depends on overseas ERP software system itself each in every
month the bottom material code condition and receiving and dispatching saves the recording
carries on but actually pushes the computation, is not nearly possible to satisfy the
finance depends on it records the account the request, this all is because the overseas
ERP software itself two limitations create, but in does not violate its original
computation rule under the premise, must break its original limitation, and overcomes the
possible situation in the certain degree which or solution all influences receiving and
dispatching saves, completely has not been by no means possible, is in the overseas ERP
software database the newly built data storage table or other newly built one kind of
other types database, Can or each time calculates after each in every month the bottom
saves the current material type, the quantity and the amount, then depends on the
procedure again but actually pushes the computation this month receives and dispatches
saves, through with the last month material type, the quantity and the amount comparison,
inferred the question the reason, then depended on the procedure automatic solution or the
prompt finance personnel ????, guaranteed financial receiving and dispatching saves
computation balance.
Prerequisite: This method also must meet the certain preliminary requirement under the
above principle, is the financial personnel must approve the ERP system material end of
the month the balance quantity and the cost, namely must acknowledge the ERP system
current stock is accurate rate; And approves each kind of returned goods difference;
2. The procedure sum accumulator shows according to the structure table
This plan needs one master routine and two auxiliary programs and four data sheets
completes.
Master routine: The master routine may repeatedly calculate from the above settlement date
until now any period of time financial receiving and dispatching saves the condition, and
completes the data comparison, the problem analysis, the question extrapolation, the
question record, the question prompt and ???? the function, the system has what kind
artificial or the system is wrong, all can guarantee the same month finance receiving and
dispatching saved with the last month data the integrity which was consistent and this
month receives and dispatches saves;
Auxiliary program A: This procedure mainly completes the data end of the month balance
processing, in order to the data browsing, the data contrast and question processing, the
balance procedure has one balance limit, namely: Before each date receiving and
dispatching record only can balance one, also the balance date must be the closing date
which the master routine just calculated finished;
Auxiliary program B: This procedure may facilitate quickly glances over historical
receiving and dispatching saves the record;
Data sheet A: Uses in to save each in every month the bottom all purchases end of the
month information, and uses in repeatedly to calculate this month data the temporary
memory table and the comparison analytical table; This table data recording cannot
increase in the certain degree;
Data sheet B: Uses in to save historical receiving and dispatching saves the record, this
data sheet record can unceasingly increase;
Data sheet C: Uses in to record each time receives and dispatches saves the estimation
problem contrast and the processing record, this data sheet record can unceasingly
increase;
Data sheet D: Uses in each in every month the bottom all manufactures type and the model,
this table data recording cannot increase in the certain procedure;
3. In procedure problem analysis, data balance and processing method
Since the master routine maintained each time receives and dispatches saves the
computation completely is all consistent with the last month data, then each kind of
influence receiving and dispatching saved how was the situation processes?
* Four sheds five enter question (hideaway)
Each material but actually pushes the at the beginning of time the amount if were smaller
than ?.1 the Yuan with the last month end of the month amount difference, the procedure on
automatically moved into this difference goes into storage in the amount. Because moves in
the average algorithm in ERP eliminates endlessly is the very normal matter, therefore
four sheds five enter the difference very is normal;
After * the material sends the material is deleted (hideaway)
The material last month end of the month also had the quantity and the amount, but current
if certainly were deleted, after certainly was sends the material is deleted, because in
SYMIX was cannot delete has the quantity the material, therefore, in the procedure on
automatically supplemented the storehouse quantity and the amount, helped the system to
continue this material the existence, but also could delete to the next month;
* Revision material code (hideaway)
If after some people revised one kind of material code (old material send material delete,
increased one new material, again took back by similar quantity and amount), the procedure
supplemented the old material sends out the recording guarantees the original material
receiving and dispatching balance mayed then, this month received and dispatched saves the
new old material handled jointly with when appears with the report form in;
* Revision material type (manufacture / purchase) (demonstration)
Because financial receiving and dispatching saves is purchase receiving and dispatching
saves, if at will changes has the stock the material type, directly will cause the current
stock amount (the end of the month amount) the increase or will reduce, therefore the
procedure, regarding will alter to the purchase the manufacture, the automatic supplement
will send the material recording maintenance receiving and dispatching balance, regarding
will change to the manufacture the purchase increases automatic supposition it for the
same month the material, the automatic supplement received the record, the maintenance
receiving and dispatching balance, under the balanced earlier period, produced the change
prompt, let the financial personnel verify the change the authenticity;
* Revision material classification (product classification) (demonstration)
If revised one material product classification, first was, it the balance and with the
last month data which saved to entire warehouse receiving and dispatching identically does
not have the influence, but affected two products classifications receives and keeps
saves, the procedure was invariable to the kind of situation maintenance, but this change
prompt for the financial personnel, let the financial personnel verify the change the
authenticity;
* The system clock is not correct either the material processing diary loses or the
accident deletes (hideaway)
If the customer section clock serious distortion or the network condition is extremely
bad, will be able to cause to receive and dispatch the record the shift or loses,
regarding this will plant the situation, the system automatically supplements consummates
its round material or receives the material record, will guarantee receiving and
dispatching saves the balance and with the last month data consistency, simultaneously
recorded the not consistent situation;
* All receiving and dispatching save the material (purchase class) automatic surveillance
(demonstration)
The master routine also has one function is carries on the monitor to all purchases in the
system service condition, if discovers it has the similar manufacture use condition, for
instance: To defines issues has the work list for the purchase material and so on, will
prompt the financial personnel gives verifies.
Other explain: The belt " the hideaway " the mark indication, this question
processing does not demonstrate in the report form, financial personnel blind, the
financial personnel only can see " demonstrates " mark question processing and
the material explanation. The system manager has the power indicates the record to the
hideaway class carries on the problem analysis, looks is operates reason or network reason
and so on, and to the user proposes the improvement opinion, unceasingly consummates the
operation and the system, unceasingly reduces the wrong record.
|
